DBA Data[Home] [Help]

APPS.PA_CI_SUPPLIER_UTILS dependencies on FND_GLOBAL

Line 473: ,p_CREATED_BY => FND_GLOBAL.login_id

469: ,p_CURRENCY_CODE => p_CURRENCY_CODE(i)
470: ,p_CHANGE_AMOUNT => p_CHANGE_AMOUNT(i)
471: ,p_CHANGE_TYPE => p_CHANGE_TYPE(i)
472: ,p_CHANGE_DESCRIPTION => p_CHANGE_DESCRIPTION(i)
473: ,p_CREATED_BY => FND_GLOBAL.login_id
474: ,p_CREATION_DATE => trunc(sysdate)
475: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id
476: ,p_LAST_UPDATE_DATE => trunc(sysdate)
477: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id

Line 475: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id

471: ,p_CHANGE_TYPE => p_CHANGE_TYPE(i)
472: ,p_CHANGE_DESCRIPTION => p_CHANGE_DESCRIPTION(i)
473: ,p_CREATED_BY => FND_GLOBAL.login_id
474: ,p_CREATION_DATE => trunc(sysdate)
475: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id
476: ,p_LAST_UPDATE_DATE => trunc(sysdate)
477: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
478: ,p_ci_status => P_CI_STATUS(i)
479: ,x_return_status => l_return_status(i)

Line 477: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id

473: ,p_CREATED_BY => FND_GLOBAL.login_id
474: ,p_CREATION_DATE => trunc(sysdate)
475: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id
476: ,p_LAST_UPDATE_DATE => trunc(sysdate)
477: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
478: ,p_ci_status => P_CI_STATUS(i)
479: ,x_return_status => l_return_status(i)
480: ,x_error_msg_code => l_error_msg_code );
481:

Line 512: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id

508: ,p_CURRENCY_CODE => p_CURRENCY_CODE(i)
509: ,p_CHANGE_AMOUNT => p_CHANGE_AMOUNT(i)
510: ,p_CHANGE_TYPE => p_CHANGE_TYPE(i)
511: ,p_CHANGE_DESCRIPTION => p_CHANGE_DESCRIPTION(i)
512: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id
513: ,p_LAST_UPDATE_DATE => trunc(sysdate)
514: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
515: ,p_ci_status => P_CI_STATUS(i)
516: ,x_return_status => l_return_status(i)

Line 514: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id

510: ,p_CHANGE_TYPE => p_CHANGE_TYPE(i)
511: ,p_CHANGE_DESCRIPTION => p_CHANGE_DESCRIPTION(i)
512: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id
513: ,p_LAST_UPDATE_DATE => trunc(sysdate)
514: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
515: ,p_ci_status => P_CI_STATUS(i)
516: ,x_return_status => l_return_status(i)
517: ,x_error_msg_code => l_error_msg_code );
518: If l_debug_mode = 'Y' THEN

Line 681: ,p_CREATED_BY => FND_GLOBAL.login_id

677: ,p_CURRENCY_CODE => p_CURRENCY_CODE
678: ,p_CHANGE_AMOUNT => p_CHANGE_AMOUNT
679: ,p_CHANGE_TYPE => p_CHANGE_TYPE
680: ,p_CHANGE_DESCRIPTION => p_CHANGE_DESCRIPTION
681: ,p_CREATED_BY => FND_GLOBAL.login_id
682: ,p_CREATION_DATE => trunc(sysdate)
683: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id
684: ,p_LAST_UPDATE_DATE => trunc(sysdate)
685: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id

Line 683: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id

679: ,p_CHANGE_TYPE => p_CHANGE_TYPE
680: ,p_CHANGE_DESCRIPTION => p_CHANGE_DESCRIPTION
681: ,p_CREATED_BY => FND_GLOBAL.login_id
682: ,p_CREATION_DATE => trunc(sysdate)
683: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id
684: ,p_LAST_UPDATE_DATE => trunc(sysdate)
685: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
686: ,p_ci_status => l_CI_STATUS
687: ,x_return_status => l_return_status

Line 685: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id

681: ,p_CREATED_BY => FND_GLOBAL.login_id
682: ,p_CREATION_DATE => trunc(sysdate)
683: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id
684: ,p_LAST_UPDATE_DATE => trunc(sysdate)
685: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
686: ,p_ci_status => l_CI_STATUS
687: ,x_return_status => l_return_status
688: ,x_error_msg_code => l_error_msg_code );
689:

Line 751: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id

747: ,p_CURRENCY_CODE => p_CURRENCY_CODE
748: ,p_CHANGE_AMOUNT => p_CHANGE_AMOUNT
749: ,p_CHANGE_TYPE => p_CHANGE_TYPE
750: ,p_CHANGE_DESCRIPTION => p_CHANGE_DESCRIPTION
751: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id
752: ,p_LAST_UPDATE_DATE => trunc(sysdate)
753: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
754: ,p_ci_status => l_CI_STATUS
755: ,x_return_status => l_return_status

Line 753: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id

749: ,p_CHANGE_TYPE => p_CHANGE_TYPE
750: ,p_CHANGE_DESCRIPTION => p_CHANGE_DESCRIPTION
751: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id
752: ,p_LAST_UPDATE_DATE => trunc(sysdate)
753: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
754: ,p_ci_status => l_CI_STATUS
755: ,x_return_status => l_return_status
756: ,x_error_msg_code => l_error_msg_code );
757: IF l_debug_mode = 'Y' THEN

Line 778: ,p_CREATED_BY => FND_GLOBAL.login_id

774: ,p_CURRENCY_CODE => p_CURRENCY_CODE
775: ,p_CHANGE_AMOUNT => p_CHANGE_AMOUNT
776: ,p_CHANGE_TYPE => p_CHANGE_TYPE
777: ,p_CHANGE_DESCRIPTION => p_CHANGE_DESCRIPTION
778: ,p_CREATED_BY => FND_GLOBAL.login_id
779: ,p_CREATION_DATE => trunc(sysdate)
780: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id
781: ,p_LAST_UPDATE_DATE => trunc(sysdate)
782: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id

Line 780: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id

776: ,p_CHANGE_TYPE => p_CHANGE_TYPE
777: ,p_CHANGE_DESCRIPTION => p_CHANGE_DESCRIPTION
778: ,p_CREATED_BY => FND_GLOBAL.login_id
779: ,p_CREATION_DATE => trunc(sysdate)
780: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id
781: ,p_LAST_UPDATE_DATE => trunc(sysdate)
782: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
783: ,p_ci_status => l_CI_STATUS
784: ,x_return_status => l_return_status

Line 782: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id

778: ,p_CREATED_BY => FND_GLOBAL.login_id
779: ,p_CREATION_DATE => trunc(sysdate)
780: ,p_LAST_UPDATED_BY => FND_GLOBAL.login_id
781: ,p_LAST_UPDATE_DATE => trunc(sysdate)
782: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
783: ,p_ci_status => l_CI_STATUS
784: ,x_return_status => l_return_status
785: ,x_error_msg_code => l_error_msg_code );
786:

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

974: ,si.CURRENCY_CODE
975: ,si.CHANGE_AMOUNT
976: ,si.CHANGE_TYPE
977: ,si.CHANGE_DESCRIPTION
978: ,NVL(FND_GLOBAL.login_id,-99)
979: ,sysdate
980: ,NVL(FND_GLOBAL.login_id,-99)
981: ,sysdate
982: ,NVL(FND_GLOBAL.login_id,-99)

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

976: ,si.CHANGE_TYPE
977: ,si.CHANGE_DESCRIPTION
978: ,NVL(FND_GLOBAL.login_id,-99)
979: ,sysdate
980: ,NVL(FND_GLOBAL.login_id,-99)
981: ,sysdate
982: ,NVL(FND_GLOBAL.login_id,-99)
983: FROM PA_CI_SUPPLIER_DETAILS si
984: ,PA_CONTROL_ITEMS ci

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

978: ,NVL(FND_GLOBAL.login_id,-99)
979: ,sysdate
980: ,NVL(FND_GLOBAL.login_id,-99)
981: ,sysdate
982: ,NVL(FND_GLOBAL.login_id,-99)
983: FROM PA_CI_SUPPLIER_DETAILS si
984: ,PA_CONTROL_ITEMS ci
985: WHERE si.CI_ID = p_from_ci_item_id
986: AND ci.ci_id = p_to_ci_item_id;