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
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)
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:
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)
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
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
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
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:
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
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
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
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
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:
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)
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
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;