DBA Data[Home] [Help]

APPS.GMF_ITEMCOST_PVT dependencies on FND_GLOBAL

Line 428: FND_GLOBAL.LOGIN_ID

424: sysdate,
425: p_user_id,
426: sysdate,
427: p_user_id,
428: FND_GLOBAL.LOGIN_ID
429: );
430:
431: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
432: THEN

Line 621: FND_GLOBAL.LOGIN_ID

617: sysdate,
618: p_user_id,
619: sysdate,
620: p_user_id,
621: FND_GLOBAL.LOGIN_ID
622: );
623:
624: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
625: THEN

Line 852: last_update_login = FND_GLOBAL.LOGIN_ID

848: ATTRIBUTE30 = decode(p_this_level_dtl_tbl(i).ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE30, p_this_level_dtl_tbl(i).ATTRIBUTE30),
849: attribute_category = decode(p_this_level_dtl_tbl(i).attribute_category, FND_API.G_MISS_CHAR, NULL, NULL, attribute_category, p_this_level_dtl_tbl(i).attribute_category),
850: last_update_date = sysdate,
851: last_updated_by = p_user_id,
852: last_update_login = FND_GLOBAL.LOGIN_ID
853: WHERE cmpntcost_id = p_this_level_dtl_tbl(i).cmpntcost_id
854: AND cost_level = 0;
855: ELSE -- delete the record i.e mark for purge
856: UPDATE cm_cmpt_dtl

Line 860: last_update_login = FND_GLOBAL.LOGIN_ID

856: UPDATE cm_cmpt_dtl
857: SET delete_mark = 1,
858: last_update_date = sysdate,
859: last_updated_by = p_user_id,
860: last_update_login = FND_GLOBAL.LOGIN_ID
861: WHERE cmpntcost_id = p_this_level_dtl_tbl(i).cmpntcost_id
862: AND cost_level = 0;
863: END IF ;
864:

Line 936: last_update_login = FND_GLOBAL.LOGIN_ID

932: ATTRIBUTE30 = decode(p_this_level_dtl_tbl(i).ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE30, p_this_level_dtl_tbl(i).ATTRIBUTE30),
933: attribute_category = decode(p_this_level_dtl_tbl(i).attribute_category, FND_API.G_MISS_CHAR, NULL, NULL, attribute_category, p_this_level_dtl_tbl(i).attribute_category),
934: last_update_date = sysdate,
935: last_updated_by = p_user_id,
936: last_update_login = FND_GLOBAL.LOGIN_ID
937: WHERE inventory_item_id = p_header_rec.inventory_item_id
938: AND organization_id = p_header_rec.organization_id
939: AND period_id = p_header_rec.period_id
940: AND cost_type_id = p_header_rec.cost_type_id

Line 949: last_update_login = FND_GLOBAL.LOGIN_ID

945: UPDATE cm_cmpt_dtl
946: SET delete_mark = 1,
947: last_update_date = sysdate,
948: last_updated_by = p_user_id,
949: last_update_login = FND_GLOBAL.LOGIN_ID
950: WHERE inventory_item_id = p_header_rec.inventory_item_id
951: AND organization_id = p_header_rec.organization_id
952: AND period_id = p_header_rec.period_id
953: AND cost_type_id = p_header_rec.cost_type_id

Line 1038: last_update_login = FND_GLOBAL.LOGIN_ID

1034: SET cmpnt_cost = decode(p_lower_level_dtl_tbl(i).cmpnt_cost, FND_API.G_MISS_NUM, NULL, NULL, cmpnt_cost, p_lower_level_dtl_tbl(i).cmpnt_cost),
1035: delete_mark = 0,
1036: last_update_date = sysdate,
1037: last_updated_by = p_user_id,
1038: last_update_login = FND_GLOBAL.LOGIN_ID
1039: WHERE cmpntcost_id = p_lower_level_dtl_tbl(i).cmpntcost_id
1040: AND cost_level = 1;
1041: ELSE
1042: UPDATE cm_cmpt_dtl

Line 1046: last_update_login = FND_GLOBAL.LOGIN_ID

1042: UPDATE cm_cmpt_dtl
1043: SET delete_mark = 1,
1044: last_update_date = sysdate,
1045: last_updated_by = p_user_id,
1046: last_update_login = FND_GLOBAL.LOGIN_ID
1047: WHERE cmpntcost_id = p_lower_level_dtl_tbl(i).cmpntcost_id
1048: AND cost_level = 1;
1049: END IF ;
1050:

Line 1087: last_update_login = FND_GLOBAL.LOGIN_ID

1083: SET cmpnt_cost = decode(p_lower_level_dtl_tbl(i).cmpnt_cost, FND_API.G_MISS_NUM, NULL, NULL, cmpnt_cost, p_lower_level_dtl_tbl(i).cmpnt_cost ),
1084: delete_mark = 0,
1085: last_update_date = sysdate,
1086: last_updated_by = p_user_id,
1087: last_update_login = FND_GLOBAL.LOGIN_ID
1088:
1089: WHERE inventory_item_id = p_header_rec.inventory_item_id
1090: AND organization_id = p_header_rec.organization_id
1091: AND period_id = p_header_rec.period_id

Line 1101: last_update_login = FND_GLOBAL.LOGIN_ID

1097: UPDATE cm_cmpt_dtl
1098: SET delete_mark = 1,
1099: last_update_date = sysdate,
1100: last_updated_by = p_user_id,
1101: last_update_login = FND_GLOBAL.LOGIN_ID
1102: WHERE inventory_item_id = p_header_rec.inventory_item_id
1103: AND organization_id = p_header_rec.organization_id
1104: AND period_id = p_header_rec.period_id
1105: AND cost_type_id = p_header_rec.cost_type_id