eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBC_ASSOCIATIONS_PKG dependencies on FND_API

Line 11: -- shitij.vatsa 11/04/2002 Updated for FND_API.G_MISS_XXX

7: -- MODIFICATION HISTORY
8: -- Person Date Comments
9: -- --------- ------ ------------------------------------------
10: -- Sri Rangarajan 01/06/2002 Created Package
11: -- shitij.vatsa 11/04/2002 Updated for FND_API.G_MISS_XXX
12: -- SHARMA 07/04/2005 Modified LOAD_ROW, TRANSLATE_ROW and created
13: -- LOAD_SEED_ROW for R12 LCT standards bug 4411674
14:
15:

Line 45: (px_association_id = Fnd_Api.G_MISS_NUM))

41:
42: -- Primary key validation check
43:
44: IF ((px_association_id IS NULL) OR
45: (px_association_id = Fnd_Api.G_MISS_NUM))
46: THEN
47: OPEN c2;
48: FETCH c2 INTO px_association_id;
49: CLOSE c2;

Line 71: ,DECODE(p_content_item_id,Fnd_Api.G_MISS_NUM,NULL,p_content_item_id)

67: ,last_update_login
68: )
69: VALUES (
70: px_association_id
71: ,DECODE(p_content_item_id,Fnd_Api.G_MISS_NUM,NULL,p_content_item_id)
72: ,DECODE(p_citem_version_id,Fnd_Api.G_MISS_NUM,NULL,p_citem_version_id)
73: ,DECODE(p_association_type_code,Fnd_Api.G_MISS_CHAR,NULL,p_association_type_code)
74: ,DECODE(p_associated_object_val1,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val1)
75: ,DECODE(p_associated_object_val2,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val2)

Line 72: ,DECODE(p_citem_version_id,Fnd_Api.G_MISS_NUM,NULL,p_citem_version_id)

68: )
69: VALUES (
70: px_association_id
71: ,DECODE(p_content_item_id,Fnd_Api.G_MISS_NUM,NULL,p_content_item_id)
72: ,DECODE(p_citem_version_id,Fnd_Api.G_MISS_NUM,NULL,p_citem_version_id)
73: ,DECODE(p_association_type_code,Fnd_Api.G_MISS_CHAR,NULL,p_association_type_code)
74: ,DECODE(p_associated_object_val1,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val1)
75: ,DECODE(p_associated_object_val2,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val2)
76: ,DECODE(p_associated_object_val3,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val3)

Line 73: ,DECODE(p_association_type_code,Fnd_Api.G_MISS_CHAR,NULL,p_association_type_code)

69: VALUES (
70: px_association_id
71: ,DECODE(p_content_item_id,Fnd_Api.G_MISS_NUM,NULL,p_content_item_id)
72: ,DECODE(p_citem_version_id,Fnd_Api.G_MISS_NUM,NULL,p_citem_version_id)
73: ,DECODE(p_association_type_code,Fnd_Api.G_MISS_CHAR,NULL,p_association_type_code)
74: ,DECODE(p_associated_object_val1,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val1)
75: ,DECODE(p_associated_object_val2,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val2)
76: ,DECODE(p_associated_object_val3,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val3)
77: ,DECODE(p_associated_object_val4,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val4)

Line 74: ,DECODE(p_associated_object_val1,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val1)

70: px_association_id
71: ,DECODE(p_content_item_id,Fnd_Api.G_MISS_NUM,NULL,p_content_item_id)
72: ,DECODE(p_citem_version_id,Fnd_Api.G_MISS_NUM,NULL,p_citem_version_id)
73: ,DECODE(p_association_type_code,Fnd_Api.G_MISS_CHAR,NULL,p_association_type_code)
74: ,DECODE(p_associated_object_val1,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val1)
75: ,DECODE(p_associated_object_val2,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val2)
76: ,DECODE(p_associated_object_val3,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val3)
77: ,DECODE(p_associated_object_val4,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val4)
78: ,DECODE(p_associated_object_val5,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val5)

Line 75: ,DECODE(p_associated_object_val2,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val2)

71: ,DECODE(p_content_item_id,Fnd_Api.G_MISS_NUM,NULL,p_content_item_id)
72: ,DECODE(p_citem_version_id,Fnd_Api.G_MISS_NUM,NULL,p_citem_version_id)
73: ,DECODE(p_association_type_code,Fnd_Api.G_MISS_CHAR,NULL,p_association_type_code)
74: ,DECODE(p_associated_object_val1,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val1)
75: ,DECODE(p_associated_object_val2,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val2)
76: ,DECODE(p_associated_object_val3,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val3)
77: ,DECODE(p_associated_object_val4,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val4)
78: ,DECODE(p_associated_object_val5,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val5)
79: ,DECODE(p_object_version_number,Fnd_Api.G_MISS_NUM,NULL,p_object_version_number)

Line 76: ,DECODE(p_associated_object_val3,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val3)

72: ,DECODE(p_citem_version_id,Fnd_Api.G_MISS_NUM,NULL,p_citem_version_id)
73: ,DECODE(p_association_type_code,Fnd_Api.G_MISS_CHAR,NULL,p_association_type_code)
74: ,DECODE(p_associated_object_val1,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val1)
75: ,DECODE(p_associated_object_val2,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val2)
76: ,DECODE(p_associated_object_val3,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val3)
77: ,DECODE(p_associated_object_val4,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val4)
78: ,DECODE(p_associated_object_val5,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val5)
79: ,DECODE(p_object_version_number,Fnd_Api.G_MISS_NUM,NULL,p_object_version_number)
80: ,DECODE(p_creation_date,Fnd_Api.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)

Line 77: ,DECODE(p_associated_object_val4,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val4)

73: ,DECODE(p_association_type_code,Fnd_Api.G_MISS_CHAR,NULL,p_association_type_code)
74: ,DECODE(p_associated_object_val1,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val1)
75: ,DECODE(p_associated_object_val2,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val2)
76: ,DECODE(p_associated_object_val3,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val3)
77: ,DECODE(p_associated_object_val4,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val4)
78: ,DECODE(p_associated_object_val5,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val5)
79: ,DECODE(p_object_version_number,Fnd_Api.G_MISS_NUM,NULL,p_object_version_number)
80: ,DECODE(p_creation_date,Fnd_Api.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
81: ,DECODE(p_created_by,Fnd_Api.G_MISS_NUM,Fnd_Global.user_id,NULL,Fnd_Global.user_id,p_created_by)

Line 78: ,DECODE(p_associated_object_val5,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val5)

74: ,DECODE(p_associated_object_val1,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val1)
75: ,DECODE(p_associated_object_val2,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val2)
76: ,DECODE(p_associated_object_val3,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val3)
77: ,DECODE(p_associated_object_val4,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val4)
78: ,DECODE(p_associated_object_val5,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val5)
79: ,DECODE(p_object_version_number,Fnd_Api.G_MISS_NUM,NULL,p_object_version_number)
80: ,DECODE(p_creation_date,Fnd_Api.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
81: ,DECODE(p_created_by,Fnd_Api.G_MISS_NUM,Fnd_Global.user_id,NULL,Fnd_Global.user_id,p_created_by)
82: ,DECODE(p_last_update_date,Fnd_Api.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)

Line 79: ,DECODE(p_object_version_number,Fnd_Api.G_MISS_NUM,NULL,p_object_version_number)

75: ,DECODE(p_associated_object_val2,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val2)
76: ,DECODE(p_associated_object_val3,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val3)
77: ,DECODE(p_associated_object_val4,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val4)
78: ,DECODE(p_associated_object_val5,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val5)
79: ,DECODE(p_object_version_number,Fnd_Api.G_MISS_NUM,NULL,p_object_version_number)
80: ,DECODE(p_creation_date,Fnd_Api.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
81: ,DECODE(p_created_by,Fnd_Api.G_MISS_NUM,Fnd_Global.user_id,NULL,Fnd_Global.user_id,p_created_by)
82: ,DECODE(p_last_update_date,Fnd_Api.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
83: ,DECODE(p_last_updated_by,Fnd_Api.G_MISS_NUM,Fnd_Global.user_id,NULL,Fnd_Global.user_id,p_last_updated_by)

Line 80: ,DECODE(p_creation_date,Fnd_Api.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)

76: ,DECODE(p_associated_object_val3,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val3)
77: ,DECODE(p_associated_object_val4,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val4)
78: ,DECODE(p_associated_object_val5,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val5)
79: ,DECODE(p_object_version_number,Fnd_Api.G_MISS_NUM,NULL,p_object_version_number)
80: ,DECODE(p_creation_date,Fnd_Api.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
81: ,DECODE(p_created_by,Fnd_Api.G_MISS_NUM,Fnd_Global.user_id,NULL,Fnd_Global.user_id,p_created_by)
82: ,DECODE(p_last_update_date,Fnd_Api.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
83: ,DECODE(p_last_updated_by,Fnd_Api.G_MISS_NUM,Fnd_Global.user_id,NULL,Fnd_Global.user_id,p_last_updated_by)
84: ,DECODE(p_last_update_login,Fnd_Api.G_MISS_NUM,Fnd_Global.login_id,NULL,Fnd_Global.user_id,p_last_update_login)

Line 81: ,DECODE(p_created_by,Fnd_Api.G_MISS_NUM,Fnd_Global.user_id,NULL,Fnd_Global.user_id,p_created_by)

77: ,DECODE(p_associated_object_val4,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val4)
78: ,DECODE(p_associated_object_val5,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val5)
79: ,DECODE(p_object_version_number,Fnd_Api.G_MISS_NUM,NULL,p_object_version_number)
80: ,DECODE(p_creation_date,Fnd_Api.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
81: ,DECODE(p_created_by,Fnd_Api.G_MISS_NUM,Fnd_Global.user_id,NULL,Fnd_Global.user_id,p_created_by)
82: ,DECODE(p_last_update_date,Fnd_Api.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
83: ,DECODE(p_last_updated_by,Fnd_Api.G_MISS_NUM,Fnd_Global.user_id,NULL,Fnd_Global.user_id,p_last_updated_by)
84: ,DECODE(p_last_update_login,Fnd_Api.G_MISS_NUM,Fnd_Global.login_id,NULL,Fnd_Global.user_id,p_last_update_login)
85: );

Line 82: ,DECODE(p_last_update_date,Fnd_Api.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)

78: ,DECODE(p_associated_object_val5,Fnd_Api.G_MISS_CHAR,NULL,p_associated_object_val5)
79: ,DECODE(p_object_version_number,Fnd_Api.G_MISS_NUM,NULL,p_object_version_number)
80: ,DECODE(p_creation_date,Fnd_Api.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
81: ,DECODE(p_created_by,Fnd_Api.G_MISS_NUM,Fnd_Global.user_id,NULL,Fnd_Global.user_id,p_created_by)
82: ,DECODE(p_last_update_date,Fnd_Api.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
83: ,DECODE(p_last_updated_by,Fnd_Api.G_MISS_NUM,Fnd_Global.user_id,NULL,Fnd_Global.user_id,p_last_updated_by)
84: ,DECODE(p_last_update_login,Fnd_Api.G_MISS_NUM,Fnd_Global.login_id,NULL,Fnd_Global.user_id,p_last_update_login)
85: );
86:

Line 83: ,DECODE(p_last_updated_by,Fnd_Api.G_MISS_NUM,Fnd_Global.user_id,NULL,Fnd_Global.user_id,p_last_updated_by)

79: ,DECODE(p_object_version_number,Fnd_Api.G_MISS_NUM,NULL,p_object_version_number)
80: ,DECODE(p_creation_date,Fnd_Api.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
81: ,DECODE(p_created_by,Fnd_Api.G_MISS_NUM,Fnd_Global.user_id,NULL,Fnd_Global.user_id,p_created_by)
82: ,DECODE(p_last_update_date,Fnd_Api.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
83: ,DECODE(p_last_updated_by,Fnd_Api.G_MISS_NUM,Fnd_Global.user_id,NULL,Fnd_Global.user_id,p_last_updated_by)
84: ,DECODE(p_last_update_login,Fnd_Api.G_MISS_NUM,Fnd_Global.login_id,NULL,Fnd_Global.user_id,p_last_update_login)
85: );
86:
87:

Line 84: ,DECODE(p_last_update_login,Fnd_Api.G_MISS_NUM,Fnd_Global.login_id,NULL,Fnd_Global.user_id,p_last_update_login)

80: ,DECODE(p_creation_date,Fnd_Api.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
81: ,DECODE(p_created_by,Fnd_Api.G_MISS_NUM,Fnd_Global.user_id,NULL,Fnd_Global.user_id,p_created_by)
82: ,DECODE(p_last_update_date,Fnd_Api.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
83: ,DECODE(p_last_updated_by,Fnd_Api.G_MISS_NUM,Fnd_Global.user_id,NULL,Fnd_Global.user_id,p_last_updated_by)
84: ,DECODE(p_last_update_login,Fnd_Api.G_MISS_NUM,Fnd_Global.login_id,NULL,Fnd_Global.user_id,p_last_update_login)
85: );
86:
87:
88:

Line 121: content_item_id = DECODE(p_content_item_id,Fnd_Api.G_MISS_NUM,NULL,NULL,content_item_id,p_content_item_id)

117: )
118: IS
119: BEGIN
120: UPDATE ibc_associations SET
121: content_item_id = DECODE(p_content_item_id,Fnd_Api.G_MISS_NUM,NULL,NULL,content_item_id,p_content_item_id)
122: ,citem_version_id = DECODE(p_citem_version_id,Fnd_Api.G_MISS_NUM,NULL,NULL,citem_version_id,p_citem_version_id)
123: ,association_type_code = DECODE(p_association_type_code,Fnd_Api.G_MISS_CHAR,NULL,NULL,association_type_code,p_association_type_code)
124: ,associated_object_val1 = DECODE(p_associated_object_val1,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val1,p_associated_object_val1)
125: ,associated_object_val2 = DECODE(p_associated_object_val2,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val2,p_associated_object_val2)

Line 122: ,citem_version_id = DECODE(p_citem_version_id,Fnd_Api.G_MISS_NUM,NULL,NULL,citem_version_id,p_citem_version_id)

118: IS
119: BEGIN
120: UPDATE ibc_associations SET
121: content_item_id = DECODE(p_content_item_id,Fnd_Api.G_MISS_NUM,NULL,NULL,content_item_id,p_content_item_id)
122: ,citem_version_id = DECODE(p_citem_version_id,Fnd_Api.G_MISS_NUM,NULL,NULL,citem_version_id,p_citem_version_id)
123: ,association_type_code = DECODE(p_association_type_code,Fnd_Api.G_MISS_CHAR,NULL,NULL,association_type_code,p_association_type_code)
124: ,associated_object_val1 = DECODE(p_associated_object_val1,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val1,p_associated_object_val1)
125: ,associated_object_val2 = DECODE(p_associated_object_val2,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val2,p_associated_object_val2)
126: ,associated_object_val3 = DECODE(p_associated_object_val3,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val3,p_associated_object_val3)

Line 123: ,association_type_code = DECODE(p_association_type_code,Fnd_Api.G_MISS_CHAR,NULL,NULL,association_type_code,p_association_type_code)

119: BEGIN
120: UPDATE ibc_associations SET
121: content_item_id = DECODE(p_content_item_id,Fnd_Api.G_MISS_NUM,NULL,NULL,content_item_id,p_content_item_id)
122: ,citem_version_id = DECODE(p_citem_version_id,Fnd_Api.G_MISS_NUM,NULL,NULL,citem_version_id,p_citem_version_id)
123: ,association_type_code = DECODE(p_association_type_code,Fnd_Api.G_MISS_CHAR,NULL,NULL,association_type_code,p_association_type_code)
124: ,associated_object_val1 = DECODE(p_associated_object_val1,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val1,p_associated_object_val1)
125: ,associated_object_val2 = DECODE(p_associated_object_val2,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val2,p_associated_object_val2)
126: ,associated_object_val3 = DECODE(p_associated_object_val3,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val3,p_associated_object_val3)
127: ,associated_object_val4 = DECODE(p_associated_object_val4,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val4,p_associated_object_val4)

Line 124: ,associated_object_val1 = DECODE(p_associated_object_val1,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val1,p_associated_object_val1)

120: UPDATE ibc_associations SET
121: content_item_id = DECODE(p_content_item_id,Fnd_Api.G_MISS_NUM,NULL,NULL,content_item_id,p_content_item_id)
122: ,citem_version_id = DECODE(p_citem_version_id,Fnd_Api.G_MISS_NUM,NULL,NULL,citem_version_id,p_citem_version_id)
123: ,association_type_code = DECODE(p_association_type_code,Fnd_Api.G_MISS_CHAR,NULL,NULL,association_type_code,p_association_type_code)
124: ,associated_object_val1 = DECODE(p_associated_object_val1,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val1,p_associated_object_val1)
125: ,associated_object_val2 = DECODE(p_associated_object_val2,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val2,p_associated_object_val2)
126: ,associated_object_val3 = DECODE(p_associated_object_val3,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val3,p_associated_object_val3)
127: ,associated_object_val4 = DECODE(p_associated_object_val4,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val4,p_associated_object_val4)
128: ,associated_object_val5 = DECODE(p_associated_object_val5,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val5,p_associated_object_val5)

Line 125: ,associated_object_val2 = DECODE(p_associated_object_val2,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val2,p_associated_object_val2)

121: content_item_id = DECODE(p_content_item_id,Fnd_Api.G_MISS_NUM,NULL,NULL,content_item_id,p_content_item_id)
122: ,citem_version_id = DECODE(p_citem_version_id,Fnd_Api.G_MISS_NUM,NULL,NULL,citem_version_id,p_citem_version_id)
123: ,association_type_code = DECODE(p_association_type_code,Fnd_Api.G_MISS_CHAR,NULL,NULL,association_type_code,p_association_type_code)
124: ,associated_object_val1 = DECODE(p_associated_object_val1,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val1,p_associated_object_val1)
125: ,associated_object_val2 = DECODE(p_associated_object_val2,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val2,p_associated_object_val2)
126: ,associated_object_val3 = DECODE(p_associated_object_val3,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val3,p_associated_object_val3)
127: ,associated_object_val4 = DECODE(p_associated_object_val4,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val4,p_associated_object_val4)
128: ,associated_object_val5 = DECODE(p_associated_object_val5,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val5,p_associated_object_val5)
129: ,last_updated_by = DECODE(p_last_updated_by,Fnd_Api.G_MISS_NUM,Fnd_Global.user_id,NULL,Fnd_Global.user_id,p_last_updated_by)

Line 126: ,associated_object_val3 = DECODE(p_associated_object_val3,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val3,p_associated_object_val3)

122: ,citem_version_id = DECODE(p_citem_version_id,Fnd_Api.G_MISS_NUM,NULL,NULL,citem_version_id,p_citem_version_id)
123: ,association_type_code = DECODE(p_association_type_code,Fnd_Api.G_MISS_CHAR,NULL,NULL,association_type_code,p_association_type_code)
124: ,associated_object_val1 = DECODE(p_associated_object_val1,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val1,p_associated_object_val1)
125: ,associated_object_val2 = DECODE(p_associated_object_val2,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val2,p_associated_object_val2)
126: ,associated_object_val3 = DECODE(p_associated_object_val3,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val3,p_associated_object_val3)
127: ,associated_object_val4 = DECODE(p_associated_object_val4,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val4,p_associated_object_val4)
128: ,associated_object_val5 = DECODE(p_associated_object_val5,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val5,p_associated_object_val5)
129: ,last_updated_by = DECODE(p_last_updated_by,Fnd_Api.G_MISS_NUM,Fnd_Global.user_id,NULL,Fnd_Global.user_id,p_last_updated_by)
130: ,last_update_date = DECODE(p_last_update_date,Fnd_Api.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)

Line 127: ,associated_object_val4 = DECODE(p_associated_object_val4,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val4,p_associated_object_val4)

123: ,association_type_code = DECODE(p_association_type_code,Fnd_Api.G_MISS_CHAR,NULL,NULL,association_type_code,p_association_type_code)
124: ,associated_object_val1 = DECODE(p_associated_object_val1,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val1,p_associated_object_val1)
125: ,associated_object_val2 = DECODE(p_associated_object_val2,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val2,p_associated_object_val2)
126: ,associated_object_val3 = DECODE(p_associated_object_val3,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val3,p_associated_object_val3)
127: ,associated_object_val4 = DECODE(p_associated_object_val4,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val4,p_associated_object_val4)
128: ,associated_object_val5 = DECODE(p_associated_object_val5,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val5,p_associated_object_val5)
129: ,last_updated_by = DECODE(p_last_updated_by,Fnd_Api.G_MISS_NUM,Fnd_Global.user_id,NULL,Fnd_Global.user_id,p_last_updated_by)
130: ,last_update_date = DECODE(p_last_update_date,Fnd_Api.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
131: ,last_update_login = DECODE(p_last_update_login,Fnd_Api.G_MISS_NUM,Fnd_Global.login_id,NULL,Fnd_Global.user_id,p_last_update_login)

Line 128: ,associated_object_val5 = DECODE(p_associated_object_val5,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val5,p_associated_object_val5)

124: ,associated_object_val1 = DECODE(p_associated_object_val1,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val1,p_associated_object_val1)
125: ,associated_object_val2 = DECODE(p_associated_object_val2,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val2,p_associated_object_val2)
126: ,associated_object_val3 = DECODE(p_associated_object_val3,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val3,p_associated_object_val3)
127: ,associated_object_val4 = DECODE(p_associated_object_val4,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val4,p_associated_object_val4)
128: ,associated_object_val5 = DECODE(p_associated_object_val5,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val5,p_associated_object_val5)
129: ,last_updated_by = DECODE(p_last_updated_by,Fnd_Api.G_MISS_NUM,Fnd_Global.user_id,NULL,Fnd_Global.user_id,p_last_updated_by)
130: ,last_update_date = DECODE(p_last_update_date,Fnd_Api.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
131: ,last_update_login = DECODE(p_last_update_login,Fnd_Api.G_MISS_NUM,Fnd_Global.login_id,NULL,Fnd_Global.user_id,p_last_update_login)
132: ,object_version_number = object_version_number + 1

Line 129: ,last_updated_by = DECODE(p_last_updated_by,Fnd_Api.G_MISS_NUM,Fnd_Global.user_id,NULL,Fnd_Global.user_id,p_last_updated_by)

125: ,associated_object_val2 = DECODE(p_associated_object_val2,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val2,p_associated_object_val2)
126: ,associated_object_val3 = DECODE(p_associated_object_val3,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val3,p_associated_object_val3)
127: ,associated_object_val4 = DECODE(p_associated_object_val4,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val4,p_associated_object_val4)
128: ,associated_object_val5 = DECODE(p_associated_object_val5,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val5,p_associated_object_val5)
129: ,last_updated_by = DECODE(p_last_updated_by,Fnd_Api.G_MISS_NUM,Fnd_Global.user_id,NULL,Fnd_Global.user_id,p_last_updated_by)
130: ,last_update_date = DECODE(p_last_update_date,Fnd_Api.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
131: ,last_update_login = DECODE(p_last_update_login,Fnd_Api.G_MISS_NUM,Fnd_Global.login_id,NULL,Fnd_Global.user_id,p_last_update_login)
132: ,object_version_number = object_version_number + 1
133: WHERE association_id = p_association_id

Line 130: ,last_update_date = DECODE(p_last_update_date,Fnd_Api.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)

126: ,associated_object_val3 = DECODE(p_associated_object_val3,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val3,p_associated_object_val3)
127: ,associated_object_val4 = DECODE(p_associated_object_val4,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val4,p_associated_object_val4)
128: ,associated_object_val5 = DECODE(p_associated_object_val5,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val5,p_associated_object_val5)
129: ,last_updated_by = DECODE(p_last_updated_by,Fnd_Api.G_MISS_NUM,Fnd_Global.user_id,NULL,Fnd_Global.user_id,p_last_updated_by)
130: ,last_update_date = DECODE(p_last_update_date,Fnd_Api.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
131: ,last_update_login = DECODE(p_last_update_login,Fnd_Api.G_MISS_NUM,Fnd_Global.login_id,NULL,Fnd_Global.user_id,p_last_update_login)
132: ,object_version_number = object_version_number + 1
133: WHERE association_id = p_association_id
134: AND object_version_number = DECODE(p_object_version_number,

Line 131: ,last_update_login = DECODE(p_last_update_login,Fnd_Api.G_MISS_NUM,Fnd_Global.login_id,NULL,Fnd_Global.user_id,p_last_update_login)

127: ,associated_object_val4 = DECODE(p_associated_object_val4,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val4,p_associated_object_val4)
128: ,associated_object_val5 = DECODE(p_associated_object_val5,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val5,p_associated_object_val5)
129: ,last_updated_by = DECODE(p_last_updated_by,Fnd_Api.G_MISS_NUM,Fnd_Global.user_id,NULL,Fnd_Global.user_id,p_last_updated_by)
130: ,last_update_date = DECODE(p_last_update_date,Fnd_Api.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
131: ,last_update_login = DECODE(p_last_update_login,Fnd_Api.G_MISS_NUM,Fnd_Global.login_id,NULL,Fnd_Global.user_id,p_last_update_login)
132: ,object_version_number = object_version_number + 1
133: WHERE association_id = p_association_id
134: AND object_version_number = DECODE(p_object_version_number,
135: Fnd_Api.g_miss_num,

Line 135: Fnd_Api.g_miss_num,

131: ,last_update_login = DECODE(p_last_update_login,Fnd_Api.G_MISS_NUM,Fnd_Global.login_id,NULL,Fnd_Global.user_id,p_last_update_login)
132: ,object_version_number = object_version_number + 1
133: WHERE association_id = p_association_id
134: AND object_version_number = DECODE(p_object_version_number,
135: Fnd_Api.g_miss_num,
136: object_version_number,
137: NULL,
138: object_version_number,
139: p_object_version_number);

Line 263: ,p_ASSOCIATED_OBJECT_VAL2 => NVL(p_ASSOCIATED_OBJECT_VAL2,Fnd_Api.G_MISS_CHAR)

259: ,p_CITEM_VERSION_ID => p_citem_version_id
260: ,p_ASSOCIATION_ID => p_association_id
261: ,p_ASSOCIATION_TYPE_CODE => p_association_type_code
262: ,p_ASSOCIATED_OBJECT_VAL1 => p_ASSOCIATED_OBJECT_VAL1
263: ,p_ASSOCIATED_OBJECT_VAL2 => NVL(p_ASSOCIATED_OBJECT_VAL2,Fnd_Api.G_MISS_CHAR)
264: ,p_ASSOCIATED_OBJECT_VAL3 => NVL(p_ASSOCIATED_OBJECT_VAL3,Fnd_Api.G_MISS_CHAR)
265: ,p_ASSOCIATED_OBJECT_VAL4 => NVL(p_ASSOCIATED_OBJECT_VAL4,Fnd_Api.G_MISS_CHAR)
266: ,p_ASSOCIATED_OBJECT_VAL5 => NVL(p_ASSOCIATED_OBJECT_VAL5,Fnd_Api.G_MISS_CHAR)
267: ,p_last_updated_by => l_user_id

Line 264: ,p_ASSOCIATED_OBJECT_VAL3 => NVL(p_ASSOCIATED_OBJECT_VAL3,Fnd_Api.G_MISS_CHAR)

260: ,p_ASSOCIATION_ID => p_association_id
261: ,p_ASSOCIATION_TYPE_CODE => p_association_type_code
262: ,p_ASSOCIATED_OBJECT_VAL1 => p_ASSOCIATED_OBJECT_VAL1
263: ,p_ASSOCIATED_OBJECT_VAL2 => NVL(p_ASSOCIATED_OBJECT_VAL2,Fnd_Api.G_MISS_CHAR)
264: ,p_ASSOCIATED_OBJECT_VAL3 => NVL(p_ASSOCIATED_OBJECT_VAL3,Fnd_Api.G_MISS_CHAR)
265: ,p_ASSOCIATED_OBJECT_VAL4 => NVL(p_ASSOCIATED_OBJECT_VAL4,Fnd_Api.G_MISS_CHAR)
266: ,p_ASSOCIATED_OBJECT_VAL5 => NVL(p_ASSOCIATED_OBJECT_VAL5,Fnd_Api.G_MISS_CHAR)
267: ,p_last_updated_by => l_user_id
268: ,p_last_update_date => SYSDATE

Line 265: ,p_ASSOCIATED_OBJECT_VAL4 => NVL(p_ASSOCIATED_OBJECT_VAL4,Fnd_Api.G_MISS_CHAR)

261: ,p_ASSOCIATION_TYPE_CODE => p_association_type_code
262: ,p_ASSOCIATED_OBJECT_VAL1 => p_ASSOCIATED_OBJECT_VAL1
263: ,p_ASSOCIATED_OBJECT_VAL2 => NVL(p_ASSOCIATED_OBJECT_VAL2,Fnd_Api.G_MISS_CHAR)
264: ,p_ASSOCIATED_OBJECT_VAL3 => NVL(p_ASSOCIATED_OBJECT_VAL3,Fnd_Api.G_MISS_CHAR)
265: ,p_ASSOCIATED_OBJECT_VAL4 => NVL(p_ASSOCIATED_OBJECT_VAL4,Fnd_Api.G_MISS_CHAR)
266: ,p_ASSOCIATED_OBJECT_VAL5 => NVL(p_ASSOCIATED_OBJECT_VAL5,Fnd_Api.G_MISS_CHAR)
267: ,p_last_updated_by => l_user_id
268: ,p_last_update_date => SYSDATE
269: ,p_last_update_login => 0

Line 266: ,p_ASSOCIATED_OBJECT_VAL5 => NVL(p_ASSOCIATED_OBJECT_VAL5,Fnd_Api.G_MISS_CHAR)

262: ,p_ASSOCIATED_OBJECT_VAL1 => p_ASSOCIATED_OBJECT_VAL1
263: ,p_ASSOCIATED_OBJECT_VAL2 => NVL(p_ASSOCIATED_OBJECT_VAL2,Fnd_Api.G_MISS_CHAR)
264: ,p_ASSOCIATED_OBJECT_VAL3 => NVL(p_ASSOCIATED_OBJECT_VAL3,Fnd_Api.G_MISS_CHAR)
265: ,p_ASSOCIATED_OBJECT_VAL4 => NVL(p_ASSOCIATED_OBJECT_VAL4,Fnd_Api.G_MISS_CHAR)
266: ,p_ASSOCIATED_OBJECT_VAL5 => NVL(p_ASSOCIATED_OBJECT_VAL5,Fnd_Api.G_MISS_CHAR)
267: ,p_last_updated_by => l_user_id
268: ,p_last_update_date => SYSDATE
269: ,p_last_update_login => 0
270: ,p_object_version_number => NULL);

Line 283: ,p_ASSOCIATED_OBJECT_VAL2 => NVL(p_ASSOCIATED_OBJECT_VAL2,Fnd_Api.G_MISS_CHAR)

279: ,p_CONTENT_ITEM_ID => p_content_item_id
280: ,p_CITEM_VERSION_ID => p_citem_version_id
281: ,p_ASSOCIATION_TYPE_CODE => p_association_type_code
282: ,p_ASSOCIATED_OBJECT_VAL1 => p_ASSOCIATED_OBJECT_VAL1
283: ,p_ASSOCIATED_OBJECT_VAL2 => NVL(p_ASSOCIATED_OBJECT_VAL2,Fnd_Api.G_MISS_CHAR)
284: ,p_ASSOCIATED_OBJECT_VAL3 => NVL(p_ASSOCIATED_OBJECT_VAL3,Fnd_Api.G_MISS_CHAR)
285: ,p_ASSOCIATED_OBJECT_VAL4 => NVL(p_ASSOCIATED_OBJECT_VAL4,Fnd_Api.G_MISS_CHAR)
286: ,p_ASSOCIATED_OBJECT_VAL5 => NVL(p_ASSOCIATED_OBJECT_VAL5,Fnd_Api.G_MISS_CHAR)
287: ,p_CREATION_DATE => SYSDATE

Line 284: ,p_ASSOCIATED_OBJECT_VAL3 => NVL(p_ASSOCIATED_OBJECT_VAL3,Fnd_Api.G_MISS_CHAR)

280: ,p_CITEM_VERSION_ID => p_citem_version_id
281: ,p_ASSOCIATION_TYPE_CODE => p_association_type_code
282: ,p_ASSOCIATED_OBJECT_VAL1 => p_ASSOCIATED_OBJECT_VAL1
283: ,p_ASSOCIATED_OBJECT_VAL2 => NVL(p_ASSOCIATED_OBJECT_VAL2,Fnd_Api.G_MISS_CHAR)
284: ,p_ASSOCIATED_OBJECT_VAL3 => NVL(p_ASSOCIATED_OBJECT_VAL3,Fnd_Api.G_MISS_CHAR)
285: ,p_ASSOCIATED_OBJECT_VAL4 => NVL(p_ASSOCIATED_OBJECT_VAL4,Fnd_Api.G_MISS_CHAR)
286: ,p_ASSOCIATED_OBJECT_VAL5 => NVL(p_ASSOCIATED_OBJECT_VAL5,Fnd_Api.G_MISS_CHAR)
287: ,p_CREATION_DATE => SYSDATE
288: ,p_CREATED_BY => l_user_id

Line 285: ,p_ASSOCIATED_OBJECT_VAL4 => NVL(p_ASSOCIATED_OBJECT_VAL4,Fnd_Api.G_MISS_CHAR)

281: ,p_ASSOCIATION_TYPE_CODE => p_association_type_code
282: ,p_ASSOCIATED_OBJECT_VAL1 => p_ASSOCIATED_OBJECT_VAL1
283: ,p_ASSOCIATED_OBJECT_VAL2 => NVL(p_ASSOCIATED_OBJECT_VAL2,Fnd_Api.G_MISS_CHAR)
284: ,p_ASSOCIATED_OBJECT_VAL3 => NVL(p_ASSOCIATED_OBJECT_VAL3,Fnd_Api.G_MISS_CHAR)
285: ,p_ASSOCIATED_OBJECT_VAL4 => NVL(p_ASSOCIATED_OBJECT_VAL4,Fnd_Api.G_MISS_CHAR)
286: ,p_ASSOCIATED_OBJECT_VAL5 => NVL(p_ASSOCIATED_OBJECT_VAL5,Fnd_Api.G_MISS_CHAR)
287: ,p_CREATION_DATE => SYSDATE
288: ,p_CREATED_BY => l_user_id
289: ,p_LAST_UPDATE_DATE => SYSDATE

Line 286: ,p_ASSOCIATED_OBJECT_VAL5 => NVL(p_ASSOCIATED_OBJECT_VAL5,Fnd_Api.G_MISS_CHAR)

282: ,p_ASSOCIATED_OBJECT_VAL1 => p_ASSOCIATED_OBJECT_VAL1
283: ,p_ASSOCIATED_OBJECT_VAL2 => NVL(p_ASSOCIATED_OBJECT_VAL2,Fnd_Api.G_MISS_CHAR)
284: ,p_ASSOCIATED_OBJECT_VAL3 => NVL(p_ASSOCIATED_OBJECT_VAL3,Fnd_Api.G_MISS_CHAR)
285: ,p_ASSOCIATED_OBJECT_VAL4 => NVL(p_ASSOCIATED_OBJECT_VAL4,Fnd_Api.G_MISS_CHAR)
286: ,p_ASSOCIATED_OBJECT_VAL5 => NVL(p_ASSOCIATED_OBJECT_VAL5,Fnd_Api.G_MISS_CHAR)
287: ,p_CREATION_DATE => SYSDATE
288: ,p_CREATED_BY => l_user_id
289: ,p_LAST_UPDATE_DATE => SYSDATE
290: ,p_LAST_UPDATED_BY => l_user_id