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.IBE_SHOPLIST_LINE_RELATION_PKG dependencies on FND_API

Line 5: l_true VARCHAR2(1) := FND_API.G_TRUE;

1: PACKAGE BODY IBE_ShopList_Line_Relation_PKG AS
2: /* $Header: IBEVSLRB.pls 115.2 2002/12/21 06:44:48 ajlee ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_ShopList_Line_Relation_PKG';
5: l_true VARCHAR2(1) := FND_API.G_TRUE;
6:
7: -- Start of Comments
8: -- Package name : IBE_ShopList_Line_Relation_PKG
9: -- Purpose :

Line 57: DECODE(p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),

53: )
54: VALUES
55: (
56: ibe_sh_shlitem_rels_s1.NEXTVAL,
57: DECODE(p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),
58: DECODE(p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),
59: DECODE(p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
60: DECODE(p_program_update_date, FND_API.G_MISS_DATE, NULL, p_program_update_date),
61: 1,

Line 58: DECODE(p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),

54: VALUES
55: (
56: ibe_sh_shlitem_rels_s1.NEXTVAL,
57: DECODE(p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),
58: DECODE(p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),
59: DECODE(p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
60: DECODE(p_program_update_date, FND_API.G_MISS_DATE, NULL, p_program_update_date),
61: 1,
62: FND_Global.User_Id,

Line 59: DECODE(p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),

55: (
56: ibe_sh_shlitem_rels_s1.NEXTVAL,
57: DECODE(p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),
58: DECODE(p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),
59: DECODE(p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
60: DECODE(p_program_update_date, FND_API.G_MISS_DATE, NULL, p_program_update_date),
61: 1,
62: FND_Global.User_Id,
63: SYSDATE,

Line 60: DECODE(p_program_update_date, FND_API.G_MISS_DATE, NULL, p_program_update_date),

56: ibe_sh_shlitem_rels_s1.NEXTVAL,
57: DECODE(p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),
58: DECODE(p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),
59: DECODE(p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
60: DECODE(p_program_update_date, FND_API.G_MISS_DATE, NULL, p_program_update_date),
61: 1,
62: FND_Global.User_Id,
63: SYSDATE,
64: FND_Global.User_Id,

Line 103: SET request_id = DECODE(p_request_id, FND_API.G_MISS_NUM, request_id, p_request_id),

99: IBE_Util.Debug('start IBE_ShopList_Line_relation_PKG.Update row');
100: END IF;
101:
102: UPDATE ibe_sh_shlitem_rels
103: SET request_id = DECODE(p_request_id, FND_API.G_MISS_NUM, request_id, p_request_id),
104: program_application_id = DECODE(p_program_application_id, FND_API.G_MISS_NUM, program_application_id, p_program_application_id),
105: program_id = DECODE(p_program_id, FND_API.G_MISS_NUM, program_id, p_program_id),
106: program_update_date = DECODE(p_program_update_date, fnd_api.g_miss_date, program_update_date, p_program_update_date),
107: object_version_number = object_version_number + 1,

Line 104: program_application_id = DECODE(p_program_application_id, FND_API.G_MISS_NUM, program_application_id, p_program_application_id),

100: END IF;
101:
102: UPDATE ibe_sh_shlitem_rels
103: SET request_id = DECODE(p_request_id, FND_API.G_MISS_NUM, request_id, p_request_id),
104: program_application_id = DECODE(p_program_application_id, FND_API.G_MISS_NUM, program_application_id, p_program_application_id),
105: program_id = DECODE(p_program_id, FND_API.G_MISS_NUM, program_id, p_program_id),
106: program_update_date = DECODE(p_program_update_date, fnd_api.g_miss_date, program_update_date, p_program_update_date),
107: object_version_number = object_version_number + 1,
108: created_by = created_by,

Line 105: program_id = DECODE(p_program_id, FND_API.G_MISS_NUM, program_id, p_program_id),

101:
102: UPDATE ibe_sh_shlitem_rels
103: SET request_id = DECODE(p_request_id, FND_API.G_MISS_NUM, request_id, p_request_id),
104: program_application_id = DECODE(p_program_application_id, FND_API.G_MISS_NUM, program_application_id, p_program_application_id),
105: program_id = DECODE(p_program_id, FND_API.G_MISS_NUM, program_id, p_program_id),
106: program_update_date = DECODE(p_program_update_date, fnd_api.g_miss_date, program_update_date, p_program_update_date),
107: object_version_number = object_version_number + 1,
108: created_by = created_by,
109: creation_date = creation_date,

Line 106: program_update_date = DECODE(p_program_update_date, fnd_api.g_miss_date, program_update_date, p_program_update_date),

102: UPDATE ibe_sh_shlitem_rels
103: SET request_id = DECODE(p_request_id, FND_API.G_MISS_NUM, request_id, p_request_id),
104: program_application_id = DECODE(p_program_application_id, FND_API.G_MISS_NUM, program_application_id, p_program_application_id),
105: program_id = DECODE(p_program_id, FND_API.G_MISS_NUM, program_id, p_program_id),
106: program_update_date = DECODE(p_program_update_date, fnd_api.g_miss_date, program_update_date, p_program_update_date),
107: object_version_number = object_version_number + 1,
108: created_by = created_by,
109: creation_date = creation_date,
110: last_updated_by = FND_Global.User_Id,

Line 113: shp_list_item_id = DECODE(p_shp_list_item_id, FND_API.G_MISS_NUM, shp_list_item_id, p_shp_list_item_id),

109: creation_date = creation_date,
110: last_updated_by = FND_Global.User_Id,
111: last_update_date = SYSDATE,
112: last_update_login = FND_Global.Login_Id,
113: shp_list_item_id = DECODE(p_shp_list_item_id, FND_API.G_MISS_NUM, shp_list_item_id, p_shp_list_item_id),
114: related_shp_list_item_id = DECODE(p_related_shp_list_item_id, FND_API.G_MISS_NUM, related_shp_list_item_id, p_related_shp_list_item_id),
115: relationship_type_code = DECODE(p_relationship_type_code, FND_API.G_MISS_CHAR, relationship_type_code, p_relationship_type_code)
116: WHERE shlitem_rel_id = p_shlitem_rel_id;
117:

Line 114: related_shp_list_item_id = DECODE(p_related_shp_list_item_id, FND_API.G_MISS_NUM, related_shp_list_item_id, p_related_shp_list_item_id),

110: last_updated_by = FND_Global.User_Id,
111: last_update_date = SYSDATE,
112: last_update_login = FND_Global.Login_Id,
113: shp_list_item_id = DECODE(p_shp_list_item_id, FND_API.G_MISS_NUM, shp_list_item_id, p_shp_list_item_id),
114: related_shp_list_item_id = DECODE(p_related_shp_list_item_id, FND_API.G_MISS_NUM, related_shp_list_item_id, p_related_shp_list_item_id),
115: relationship_type_code = DECODE(p_relationship_type_code, FND_API.G_MISS_CHAR, relationship_type_code, p_relationship_type_code)
116: WHERE shlitem_rel_id = p_shlitem_rel_id;
117:
118: IF (SQL%NOTFOUND) THEN

Line 115: relationship_type_code = DECODE(p_relationship_type_code, FND_API.G_MISS_CHAR, relationship_type_code, p_relationship_type_code)

111: last_update_date = SYSDATE,
112: last_update_login = FND_Global.Login_Id,
113: shp_list_item_id = DECODE(p_shp_list_item_id, FND_API.G_MISS_NUM, shp_list_item_id, p_shp_list_item_id),
114: related_shp_list_item_id = DECODE(p_related_shp_list_item_id, FND_API.G_MISS_NUM, related_shp_list_item_id, p_related_shp_list_item_id),
115: relationship_type_code = DECODE(p_relationship_type_code, FND_API.G_MISS_CHAR, relationship_type_code, p_relationship_type_code)
116: WHERE shlitem_rel_id = p_shlitem_rel_id;
117:
118: IF (SQL%NOTFOUND) THEN
119: RAISE NO_DATA_FOUND;