DBA Data[Home] [Help]

APPS.PA_CI_SUPPLIER_UTILS dependencies on FND_GLOBAL

Line 704: ,p_CREATED_BY => FND_GLOBAL.login_id

700: ,p_CURRENCY_CODE => p_CURRENCY_CODE(i)
701: ,p_CHANGE_AMOUNT => p_CHANGE_AMOUNT(i)
702: ,p_CHANGE_TYPE => p_CHANGE_TYPE(i)
703: ,p_CHANGE_DESCRIPTION => p_CHANGE_DESCRIPTION(i)
704: ,p_CREATED_BY => FND_GLOBAL.login_id
705: ,p_CREATION_DATE => trunc(sysdate)
706: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id
707: ,p_LAST_UPDATE_DATE => trunc(sysdate)
708: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id

Line 706: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id

702: ,p_CHANGE_TYPE => p_CHANGE_TYPE(i)
703: ,p_CHANGE_DESCRIPTION => p_CHANGE_DESCRIPTION(i)
704: ,p_CREATED_BY => FND_GLOBAL.login_id
705: ,p_CREATION_DATE => trunc(sysdate)
706: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id
707: ,p_LAST_UPDATE_DATE => trunc(sysdate)
708: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
709: ,p_Task_Id => p_Task_Id(i)
710: ,p_Resource_List_Mem_Id => p_Resource_List_Mem_Id(i)

Line 708: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id

704: ,p_CREATED_BY => FND_GLOBAL.login_id
705: ,p_CREATION_DATE => trunc(sysdate)
706: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id
707: ,p_LAST_UPDATE_DATE => trunc(sysdate)
708: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
709: ,p_Task_Id => p_Task_Id(i)
710: ,p_Resource_List_Mem_Id => p_Resource_List_Mem_Id(i)
711: ,p_From_Date => p_From_Date(i)
712: ,p_To_Date => p_To_Date(i)

Line 765: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id

761: ,p_CURRENCY_CODE => p_CURRENCY_CODE(i)
762: ,p_CHANGE_AMOUNT => p_CHANGE_AMOUNT(i)
763: ,p_CHANGE_TYPE => p_CHANGE_TYPE(i)
764: ,p_CHANGE_DESCRIPTION => p_CHANGE_DESCRIPTION(i)
765: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id
766: ,p_LAST_UPDATE_DATE => trunc(sysdate)
767: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
768: ,p_Task_Id => p_Task_Id(i)
769: ,p_Resource_List_Mem_Id => p_Resource_List_Mem_Id(i)

Line 767: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id

763: ,p_CHANGE_TYPE => p_CHANGE_TYPE(i)
764: ,p_CHANGE_DESCRIPTION => p_CHANGE_DESCRIPTION(i)
765: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id
766: ,p_LAST_UPDATE_DATE => trunc(sysdate)
767: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
768: ,p_Task_Id => p_Task_Id(i)
769: ,p_Resource_List_Mem_Id => p_Resource_List_Mem_Id(i)
770: ,p_From_Date => p_From_Date(i)
771: ,p_To_Date => p_To_Date(i)

Line 1032: ,p_CREATED_BY => FND_GLOBAL.login_id

1028: ,p_CURRENCY_CODE => p_CURRENCY_CODE
1029: ,p_CHANGE_AMOUNT => p_CHANGE_AMOUNT
1030: ,p_CHANGE_TYPE => p_CHANGE_TYPE
1031: ,p_CHANGE_DESCRIPTION => p_CHANGE_DESCRIPTION
1032: ,p_CREATED_BY => FND_GLOBAL.login_id
1033: ,p_CREATION_DATE => trunc(sysdate)
1034: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id
1035: ,p_LAST_UPDATE_DATE => trunc(sysdate)
1036: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id

Line 1034: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id

1030: ,p_CHANGE_TYPE => p_CHANGE_TYPE
1031: ,p_CHANGE_DESCRIPTION => p_CHANGE_DESCRIPTION
1032: ,p_CREATED_BY => FND_GLOBAL.login_id
1033: ,p_CREATION_DATE => trunc(sysdate)
1034: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id
1035: ,p_LAST_UPDATE_DATE => trunc(sysdate)
1036: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
1037: ,p_Task_Id => p_Task_Id
1038: ,p_Resource_List_Mem_Id => p_Resource_List_Mem_Id

Line 1036: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id

1032: ,p_CREATED_BY => FND_GLOBAL.login_id
1033: ,p_CREATION_DATE => trunc(sysdate)
1034: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id
1035: ,p_LAST_UPDATE_DATE => trunc(sysdate)
1036: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
1037: ,p_Task_Id => p_Task_Id
1038: ,p_Resource_List_Mem_Id => p_Resource_List_Mem_Id
1039: ,p_From_Date => p_From_Date
1040: ,p_To_Date => p_To_Date

Line 1101: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id

1097: ,p_CURRENCY_CODE => p_CURRENCY_CODE
1098: ,p_CHANGE_AMOUNT => p_CHANGE_AMOUNT
1099: ,p_CHANGE_TYPE => p_CHANGE_TYPE
1100: ,p_CHANGE_DESCRIPTION => p_CHANGE_DESCRIPTION
1101: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id
1102: ,p_LAST_UPDATE_DATE => trunc(sysdate)
1103: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
1104: ,p_Task_Id => p_Task_Id
1105: ,p_Resource_List_Mem_Id => p_Resource_List_Mem_Id

Line 1103: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id

1099: ,p_CHANGE_TYPE => p_CHANGE_TYPE
1100: ,p_CHANGE_DESCRIPTION => p_CHANGE_DESCRIPTION
1101: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id
1102: ,p_LAST_UPDATE_DATE => trunc(sysdate)
1103: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
1104: ,p_Task_Id => p_Task_Id
1105: ,p_Resource_List_Mem_Id => p_Resource_List_Mem_Id
1106: ,p_From_Date => p_From_Date
1107: ,p_To_Date => p_To_Date

Line 1151: ,p_CREATED_BY => FND_GLOBAL.login_id

1147: ,p_CURRENCY_CODE => p_CURRENCY_CODE
1148: ,p_CHANGE_AMOUNT => p_CHANGE_AMOUNT
1149: ,p_CHANGE_TYPE => p_CHANGE_TYPE
1150: ,p_CHANGE_DESCRIPTION => p_CHANGE_DESCRIPTION
1151: ,p_CREATED_BY => FND_GLOBAL.login_id
1152: ,p_CREATION_DATE => trunc(sysdate)
1153: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id
1154: ,p_LAST_UPDATE_DATE => trunc(sysdate)
1155: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id

Line 1153: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id

1149: ,p_CHANGE_TYPE => p_CHANGE_TYPE
1150: ,p_CHANGE_DESCRIPTION => p_CHANGE_DESCRIPTION
1151: ,p_CREATED_BY => FND_GLOBAL.login_id
1152: ,p_CREATION_DATE => trunc(sysdate)
1153: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id
1154: ,p_LAST_UPDATE_DATE => trunc(sysdate)
1155: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
1156: ,p_Task_Id => p_Task_Id
1157: ,p_Resource_List_Mem_Id => p_Resource_List_Mem_Id

Line 1155: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id

1151: ,p_CREATED_BY => FND_GLOBAL.login_id
1152: ,p_CREATION_DATE => trunc(sysdate)
1153: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id
1154: ,p_LAST_UPDATE_DATE => trunc(sysdate)
1155: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
1156: ,p_Task_Id => p_Task_Id
1157: ,p_Resource_List_Mem_Id => p_Resource_List_Mem_Id
1158: ,p_From_Date => p_From_Date
1159: ,p_To_Date => p_To_Date

Line 1373: ,NVL(FND_GLOBAL.login_id,-99)

1369: ,si.CURRENCY_CODE
1370: ,si.CHANGE_AMOUNT
1371: ,si.CHANGE_TYPE
1372: ,si.CHANGE_DESCRIPTION
1373: ,NVL(FND_GLOBAL.login_id,-99)
1374: ,sysdate
1375: ,NVL(FND_GLOBAL.login_id,-99)
1376: ,sysdate
1377: ,NVL(FND_GLOBAL.login_id,-99)

Line 1375: ,NVL(FND_GLOBAL.login_id,-99)

1371: ,si.CHANGE_TYPE
1372: ,si.CHANGE_DESCRIPTION
1373: ,NVL(FND_GLOBAL.login_id,-99)
1374: ,sysdate
1375: ,NVL(FND_GLOBAL.login_id,-99)
1376: ,sysdate
1377: ,NVL(FND_GLOBAL.login_id,-99)
1378: FROM PA_CI_SUPPLIER_DETAILS si
1379: ,PA_CONTROL_ITEMS ci

Line 1377: ,NVL(FND_GLOBAL.login_id,-99)

1373: ,NVL(FND_GLOBAL.login_id,-99)
1374: ,sysdate
1375: ,NVL(FND_GLOBAL.login_id,-99)
1376: ,sysdate
1377: ,NVL(FND_GLOBAL.login_id,-99)
1378: FROM PA_CI_SUPPLIER_DETAILS si
1379: ,PA_CONTROL_ITEMS ci
1380: WHERE si.CI_ID = p_from_ci_item_id
1381: AND ci.ci_id = p_to_ci_item_id;

Line 2125: ,p_CREATED_BY => FND_GLOBAL.login_id

2121: ,p_CURRENCY_CODE => l_currency_code
2122: ,p_CHANGE_AMOUNT => l_change_amount
2123: ,p_CHANGE_TYPE => l_change_type
2124: ,p_CHANGE_DESCRIPTION => l_change_description
2125: ,p_CREATED_BY => FND_GLOBAL.login_id
2126: ,p_CREATION_DATE => trunc(sysdate)
2127: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id
2128: ,p_LAST_UPDATE_DATE => trunc(sysdate)
2129: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id

Line 2127: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id

2123: ,p_CHANGE_TYPE => l_change_type
2124: ,p_CHANGE_DESCRIPTION => l_change_description
2125: ,p_CREATED_BY => FND_GLOBAL.login_id
2126: ,p_CREATION_DATE => trunc(sysdate)
2127: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id
2128: ,p_LAST_UPDATE_DATE => trunc(sysdate)
2129: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
2130: ,p_Task_Id => l_task_id
2131: ,p_Resource_List_Mem_Id => l_resource_list_member_id

Line 2129: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id

2125: ,p_CREATED_BY => FND_GLOBAL.login_id
2126: ,p_CREATION_DATE => trunc(sysdate)
2127: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id
2128: ,p_LAST_UPDATE_DATE => trunc(sysdate)
2129: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
2130: ,p_Task_Id => l_task_id
2131: ,p_Resource_List_Mem_Id => l_resource_list_member_id
2132: ,p_From_Date => l_from_change_date
2133: ,p_To_Date => l_to_change_date

Line 2258: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id

2254: ,p_CURRENCY_CODE => l_currency_code
2255: ,p_CHANGE_AMOUNT => l_change_amount
2256: ,p_CHANGE_TYPE => l_change_type
2257: ,p_CHANGE_DESCRIPTION => l_change_description
2258: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id
2259: ,p_LAST_UPDATE_DATE => trunc(sysdate)
2260: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
2261: ,p_Task_Id => l_task_id
2262: ,p_Resource_List_Mem_Id => l_resource_list_member_id

Line 2260: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id

2256: ,p_CHANGE_TYPE => l_change_type
2257: ,p_CHANGE_DESCRIPTION => l_change_description
2258: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id
2259: ,p_LAST_UPDATE_DATE => trunc(sysdate)
2260: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
2261: ,p_Task_Id => l_task_id
2262: ,p_Resource_List_Mem_Id => l_resource_list_member_id
2263: ,p_From_Date => l_from_change_date
2264: ,p_To_Date => l_to_change_date