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,
65: SYSDATE,
66: FND_Global.Login_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,
65: SYSDATE,
66: FND_Global.Login_Id,
67: p_shp_list_item_id,
68: p_related_shp_list_item_id,
62: FND_Global.User_Id,
63: SYSDATE,
64: FND_Global.User_Id,
65: SYSDATE,
66: FND_Global.Login_Id,
67: p_shp_list_item_id,
68: p_related_shp_list_item_id,
69: p_relationship_type_code
70: )
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,
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),
108: created_by = created_by,
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;