DBA Data[Home] [Help]

APPS.GMF_ITEMCOST_PVT dependencies on FND_GLOBAL

Line 425: FND_GLOBAL.LOGIN_ID

421: sysdate,
422: p_user_id,
423: sysdate,
424: p_user_id,
425: FND_GLOBAL.LOGIN_ID
426: );
427:
428: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
429: THEN

Line 618: FND_GLOBAL.LOGIN_ID

614: sysdate,
615: p_user_id,
616: sysdate,
617: p_user_id,
618: FND_GLOBAL.LOGIN_ID
619: );
620:
621: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
622: THEN

Line 849: last_update_login = FND_GLOBAL.LOGIN_ID

845: ATTRIBUTE30 = decode(p_this_level_dtl_tbl(i).ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE30, p_this_level_dtl_tbl(i).ATTRIBUTE30),
846: 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),
847: last_update_date = sysdate,
848: last_updated_by = p_user_id,
849: last_update_login = FND_GLOBAL.LOGIN_ID
850: WHERE cmpntcost_id = p_this_level_dtl_tbl(i).cmpntcost_id
851: AND cost_level = 0;
852: ELSE -- delete the record i.e mark for purge
853: UPDATE cm_cmpt_dtl

Line 857: last_update_login = FND_GLOBAL.LOGIN_ID

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

Line 933: last_update_login = FND_GLOBAL.LOGIN_ID

929: ATTRIBUTE30 = decode(p_this_level_dtl_tbl(i).ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE30, p_this_level_dtl_tbl(i).ATTRIBUTE30),
930: 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),
931: last_update_date = sysdate,
932: last_updated_by = p_user_id,
933: last_update_login = FND_GLOBAL.LOGIN_ID
934: WHERE inventory_item_id = p_header_rec.inventory_item_id
935: AND organization_id = p_header_rec.organization_id
936: AND period_id = p_header_rec.period_id
937: AND cost_type_id = p_header_rec.cost_type_id

Line 946: last_update_login = FND_GLOBAL.LOGIN_ID

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

Line 1035: last_update_login = FND_GLOBAL.LOGIN_ID

1031: 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),
1032: delete_mark = 0,
1033: last_update_date = sysdate,
1034: last_updated_by = p_user_id,
1035: last_update_login = FND_GLOBAL.LOGIN_ID
1036: WHERE cmpntcost_id = p_lower_level_dtl_tbl(i).cmpntcost_id
1037: AND cost_level = 1;
1038: ELSE
1039: UPDATE cm_cmpt_dtl

Line 1043: last_update_login = FND_GLOBAL.LOGIN_ID

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

Line 1084: last_update_login = FND_GLOBAL.LOGIN_ID

1080: 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 ),
1081: delete_mark = 0,
1082: last_update_date = sysdate,
1083: last_updated_by = p_user_id,
1084: last_update_login = FND_GLOBAL.LOGIN_ID
1085:
1086: WHERE inventory_item_id = p_header_rec.inventory_item_id
1087: AND organization_id = p_header_rec.organization_id
1088: AND period_id = p_header_rec.period_id

Line 1098: last_update_login = FND_GLOBAL.LOGIN_ID

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