eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PN_SOI_VOL_IMPORT dependencies on FND_PROFILE

Line 392: ,NVL(fnd_profile.value('USER_ID'), 0)

388: ,REPORTING_DATE)
389: VALUES (PN_VAR_VOL_HIST_S.NEXTVAL
390: ,v_vol_hist_num
391: ,sysDATE
392: ,NVL(fnd_profile.value('USER_ID'), 0)
393: ,sysDATE
394: ,NVL(fnd_profile.value('USER_ID'), 0)
395: ,NVL(fnd_profile.value('USER_ID'), 0)
396: ,v_lines.line_item_id

Line 394: ,NVL(fnd_profile.value('USER_ID'), 0)

390: ,v_vol_hist_num
391: ,sysDATE
392: ,NVL(fnd_profile.value('USER_ID'), 0)
393: ,sysDATE
394: ,NVL(fnd_profile.value('USER_ID'), 0)
395: ,NVL(fnd_profile.value('USER_ID'), 0)
396: ,v_lines.line_item_id
397: ,v_period_id
398: ,v_lines.rep_str_DATE

Line 395: ,NVL(fnd_profile.value('USER_ID'), 0)

391: ,sysDATE
392: ,NVL(fnd_profile.value('USER_ID'), 0)
393: ,sysDATE
394: ,NVL(fnd_profile.value('USER_ID'), 0)
395: ,NVL(fnd_profile.value('USER_ID'), 0)
396: ,v_lines.line_item_id
397: ,v_period_id
398: ,v_lines.rep_str_DATE
399: ,v_lines.rep_end_DATE

Line 469: ,NVL(fnd_profile.value('USER_ID'), 0)

465: ,REPORTING_DATE)
466: VALUES (PN_VAR_VOL_HIST_S.NEXTVAL
467: ,v_vol_hist_num
468: ,sysDATE
469: ,NVL(fnd_profile.value('USER_ID'), 0)
470: ,sysDATE
471: ,NVL(fnd_profile.value('USER_ID'), 0)
472: ,NVL(fnd_profile.value('USER_ID'), 0)
473: ,v_lines.line_item_id

Line 471: ,NVL(fnd_profile.value('USER_ID'), 0)

467: ,v_vol_hist_num
468: ,sysDATE
469: ,NVL(fnd_profile.value('USER_ID'), 0)
470: ,sysDATE
471: ,NVL(fnd_profile.value('USER_ID'), 0)
472: ,NVL(fnd_profile.value('USER_ID'), 0)
473: ,v_lines.line_item_id
474: ,v_period_id
475: ,v_lines.rep_str_DATE

Line 472: ,NVL(fnd_profile.value('USER_ID'), 0)

468: ,sysDATE
469: ,NVL(fnd_profile.value('USER_ID'), 0)
470: ,sysDATE
471: ,NVL(fnd_profile.value('USER_ID'), 0)
472: ,NVL(fnd_profile.value('USER_ID'), 0)
473: ,v_lines.line_item_id
474: ,v_period_id
475: ,v_lines.rep_str_DATE
476: ,v_lines.rep_end_DATE

Line 499: ,LAST_UPDATED_BY = NVL(fnd_profile.value('USER_ID'), 0)

495:
496: UPDATE PN_VAR_VOL_HIST_ALL
497: SET ACTUAL_AMOUNT = v_act_amount
498: ,LAST_UPDATE_DATE =sysDATE
499: ,LAST_UPDATED_BY = NVL(fnd_profile.value('USER_ID'), 0)
500: ,LAST_UPDATE_LOGIN =NVL(fnd_profile.value('USER_ID'), 0)
501: WHERE LINE_ITEM_ID = v_lines.line_item_id
502: AND PERIOD_ID = v_period_id
503: AND GRP_DATE_ID = v_group_DATE_id

Line 500: ,LAST_UPDATE_LOGIN =NVL(fnd_profile.value('USER_ID'), 0)

496: UPDATE PN_VAR_VOL_HIST_ALL
497: SET ACTUAL_AMOUNT = v_act_amount
498: ,LAST_UPDATE_DATE =sysDATE
499: ,LAST_UPDATED_BY = NVL(fnd_profile.value('USER_ID'), 0)
500: ,LAST_UPDATE_LOGIN =NVL(fnd_profile.value('USER_ID'), 0)
501: WHERE LINE_ITEM_ID = v_lines.line_item_id
502: AND PERIOD_ID = v_period_id
503: AND GRP_DATE_ID = v_group_DATE_id
504: AND START_DATE = v_lines.rep_str_DATE

Line 544: ,NVL(fnd_profile.value('USER_ID'), 0)

540: ,REPORTING_DATE)
541: VALUES (PN_VAR_VOL_HIST_S.NEXTVAL
542: ,v_vol_hist_num
543: ,sysDATE
544: ,NVL(fnd_profile.value('USER_ID'), 0)
545: ,sysDATE
546: ,NVL(fnd_profile.value('USER_ID'), 0)
547: ,NVL(fnd_profile.value('USER_ID'), 0)
548: ,v_lines.line_item_id

Line 546: ,NVL(fnd_profile.value('USER_ID'), 0)

542: ,v_vol_hist_num
543: ,sysDATE
544: ,NVL(fnd_profile.value('USER_ID'), 0)
545: ,sysDATE
546: ,NVL(fnd_profile.value('USER_ID'), 0)
547: ,NVL(fnd_profile.value('USER_ID'), 0)
548: ,v_lines.line_item_id
549: ,v_period_id
550: ,v_lines.rep_str_DATE

Line 547: ,NVL(fnd_profile.value('USER_ID'), 0)

543: ,sysDATE
544: ,NVL(fnd_profile.value('USER_ID'), 0)
545: ,sysDATE
546: ,NVL(fnd_profile.value('USER_ID'), 0)
547: ,NVL(fnd_profile.value('USER_ID'), 0)
548: ,v_lines.line_item_id
549: ,v_period_id
550: ,v_lines.rep_str_DATE
551: ,v_lines.rep_end_DATE

Line 624: ,NVL(fnd_profile.value('USER_ID'), 0)

620: ,REPORTING_DATE)
621: VALUES (PN_VAR_VOL_HIST_S.NEXTVAL
622: ,v_vol_hist_num
623: ,sysDATE
624: ,NVL(fnd_profile.value('USER_ID'), 0)
625: ,sysDATE
626: ,NVL(fnd_profile.value('USER_ID'), 0)
627: ,NVL(fnd_profile.value('USER_ID'), 0)
628: ,v_lines.line_item_id

Line 626: ,NVL(fnd_profile.value('USER_ID'), 0)

622: ,v_vol_hist_num
623: ,sysDATE
624: ,NVL(fnd_profile.value('USER_ID'), 0)
625: ,sysDATE
626: ,NVL(fnd_profile.value('USER_ID'), 0)
627: ,NVL(fnd_profile.value('USER_ID'), 0)
628: ,v_lines.line_item_id
629: ,v_period_id
630: ,v_lines.rep_str_DATE

Line 627: ,NVL(fnd_profile.value('USER_ID'), 0)

623: ,sysDATE
624: ,NVL(fnd_profile.value('USER_ID'), 0)
625: ,sysDATE
626: ,NVL(fnd_profile.value('USER_ID'), 0)
627: ,NVL(fnd_profile.value('USER_ID'), 0)
628: ,v_lines.line_item_id
629: ,v_period_id
630: ,v_lines.rep_str_DATE
631: ,v_lines.rep_end_DATE

Line 654: ,LAST_UPDATED_BY = NVL(fnd_profile.value('USER_ID'), 0)

650:
651: UPDATE PN_VAR_VOL_HIST_ALl
652: SET FORECASTED_AMOUNT = v_frc_amount
653: ,LAST_UPDATE_DATE =sysDATE
654: ,LAST_UPDATED_BY = NVL(fnd_profile.value('USER_ID'), 0)
655: ,LAST_UPDATE_LOGIN =NVL(fnd_profile.value('USER_ID'), 0)
656: WHERE LINE_ITEM_ID = v_lines.line_item_id
657: AND PERIOD_ID = v_period_id
658: AND GRP_DATE_ID = v_group_DATE_id

Line 655: ,LAST_UPDATE_LOGIN =NVL(fnd_profile.value('USER_ID'), 0)

651: UPDATE PN_VAR_VOL_HIST_ALl
652: SET FORECASTED_AMOUNT = v_frc_amount
653: ,LAST_UPDATE_DATE =sysDATE
654: ,LAST_UPDATED_BY = NVL(fnd_profile.value('USER_ID'), 0)
655: ,LAST_UPDATE_LOGIN =NVL(fnd_profile.value('USER_ID'), 0)
656: WHERE LINE_ITEM_ID = v_lines.line_item_id
657: AND PERIOD_ID = v_period_id
658: AND GRP_DATE_ID = v_group_DATE_id
659: AND START_DATE = v_lines.rep_str_DATE

Line 698: ,NVL(fnd_profile.value('USER_ID'), 0)

694: ,REPORTING_DATE)
695: VALUES (PN_VAR_VOL_HIST_S.NEXTVAL
696: ,v_vol_hist_num
697: ,sysDATE
698: ,NVL(fnd_profile.value('USER_ID'), 0)
699: ,sysDATE
700: ,NVL(fnd_profile.value('USER_ID'), 0)
701: ,NVL(fnd_profile.value('USER_ID'), 0)
702: ,v_lines.line_item_id

Line 700: ,NVL(fnd_profile.value('USER_ID'), 0)

696: ,v_vol_hist_num
697: ,sysDATE
698: ,NVL(fnd_profile.value('USER_ID'), 0)
699: ,sysDATE
700: ,NVL(fnd_profile.value('USER_ID'), 0)
701: ,NVL(fnd_profile.value('USER_ID'), 0)
702: ,v_lines.line_item_id
703: ,v_period_id
704: ,v_lines.rep_str_DATE

Line 701: ,NVL(fnd_profile.value('USER_ID'), 0)

697: ,sysDATE
698: ,NVL(fnd_profile.value('USER_ID'), 0)
699: ,sysDATE
700: ,NVL(fnd_profile.value('USER_ID'), 0)
701: ,NVL(fnd_profile.value('USER_ID'), 0)
702: ,v_lines.line_item_id
703: ,v_period_id
704: ,v_lines.rep_str_DATE
705: ,v_lines.rep_end_DATE

Line 810: ,NVL(fnd_profile.value('USER_ID'), 0)

806: )
807: SELECT
808: PN_VAR_VOL_ARCH_S.nextval
809: ,sysDATE
810: ,NVL(fnd_profile.value('USER_ID'), 0)
811: ,sysDATE
812: ,NVL(fnd_profile.value('USER_ID'), 0)
813: ,NVL(fnd_profile.value('USER_ID'), 0)
814: ,PN_SOI_VOL_IMPORT.g_org_id

Line 812: ,NVL(fnd_profile.value('USER_ID'), 0)

808: PN_VAR_VOL_ARCH_S.nextval
809: ,sysDATE
810: ,NVL(fnd_profile.value('USER_ID'), 0)
811: ,sysDATE
812: ,NVL(fnd_profile.value('USER_ID'), 0)
813: ,NVL(fnd_profile.value('USER_ID'), 0)
814: ,PN_SOI_VOL_IMPORT.g_org_id
815: ,VOL_HIST_ID
816: ,VOL_HIST_NUM

Line 813: ,NVL(fnd_profile.value('USER_ID'), 0)

809: ,sysDATE
810: ,NVL(fnd_profile.value('USER_ID'), 0)
811: ,sysDATE
812: ,NVL(fnd_profile.value('USER_ID'), 0)
813: ,NVL(fnd_profile.value('USER_ID'), 0)
814: ,PN_SOI_VOL_IMPORT.g_org_id
815: ,VOL_HIST_ID
816: ,VOL_HIST_NUM
817: ,LAST_UPDATE_DATE

Line 865: ,LAST_UPDATED_BY = NVL(fnd_profile.value('USER_ID'), 0)

861: WHERE VOL_HIST_ID = v_lines.vol_deduct_id;
862:
863: UPDATE PN_VAR_VOL_HIST_ALL
864: SET LAST_UPDATE_DATE = sysDATE
865: ,LAST_UPDATED_BY = NVL(fnd_profile.value('USER_ID'), 0)
866: ,LAST_UPDATE_LOGIN = NVL(fnd_profile.value('USER_ID'), 0)
867: ,LINE_ITEM_ID = v_lines.line_item_id
868: ,START_DATE = v_lines.rep_str_DATE
869: ,END_DATE = v_lines.rep_end_DATE

Line 866: ,LAST_UPDATE_LOGIN = NVL(fnd_profile.value('USER_ID'), 0)

862:
863: UPDATE PN_VAR_VOL_HIST_ALL
864: SET LAST_UPDATE_DATE = sysDATE
865: ,LAST_UPDATED_BY = NVL(fnd_profile.value('USER_ID'), 0)
866: ,LAST_UPDATE_LOGIN = NVL(fnd_profile.value('USER_ID'), 0)
867: ,LINE_ITEM_ID = v_lines.line_item_id
868: ,START_DATE = v_lines.rep_str_DATE
869: ,END_DATE = v_lines.rep_end_DATE
870: ,VOL_HIST_STATUS_CODE = v_lines.vol_hist_status_code

Line 922: ,NVL(fnd_profile.value('USER_ID'), 0)

918: ,org_id)
919: VALUES (PN_VAR_DEDUCTIONS_S.NEXTVAL
920: ,v_ded_num
921: ,sysDATE
922: ,NVL(fnd_profile.value('USER_ID'), 0)
923: ,sysDATE
924: ,NVL(fnd_profile.value('USER_ID'), 0)
925: ,NVL(fnd_profile.value('USER_ID'), 0)
926: ,v_lines.line_item_id

Line 924: ,NVL(fnd_profile.value('USER_ID'), 0)

920: ,v_ded_num
921: ,sysDATE
922: ,NVL(fnd_profile.value('USER_ID'), 0)
923: ,sysDATE
924: ,NVL(fnd_profile.value('USER_ID'), 0)
925: ,NVL(fnd_profile.value('USER_ID'), 0)
926: ,v_lines.line_item_id
927: ,v_period_id
928: ,v_lines.rep_str_DATE

Line 925: ,NVL(fnd_profile.value('USER_ID'), 0)

921: ,sysDATE
922: ,NVL(fnd_profile.value('USER_ID'), 0)
923: ,sysDATE
924: ,NVL(fnd_profile.value('USER_ID'), 0)
925: ,NVL(fnd_profile.value('USER_ID'), 0)
926: ,v_lines.line_item_id
927: ,v_period_id
928: ,v_lines.rep_str_DATE
929: ,v_lines.rep_end_DATE

Line 1002: ,NVL(fnd_profile.value('USER_ID'), 0)

998: )
999: SELECT
1000: PN_VAR_DEDUCT_ARCH_S.nextval
1001: ,sysDATE
1002: ,NVL(fnd_profile.value('USER_ID'), 0)
1003: ,sysDATE
1004: ,NVL(fnd_profile.value('USER_ID'), 0)
1005: ,NVL(fnd_profile.value('USER_ID'), 0)
1006: ,PN_SOI_VOL_IMPORT.g_org_id

Line 1004: ,NVL(fnd_profile.value('USER_ID'), 0)

1000: PN_VAR_DEDUCT_ARCH_S.nextval
1001: ,sysDATE
1002: ,NVL(fnd_profile.value('USER_ID'), 0)
1003: ,sysDATE
1004: ,NVL(fnd_profile.value('USER_ID'), 0)
1005: ,NVL(fnd_profile.value('USER_ID'), 0)
1006: ,PN_SOI_VOL_IMPORT.g_org_id
1007: ,DEDUCTION_ID
1008: ,DEDUCTION_NUM

Line 1005: ,NVL(fnd_profile.value('USER_ID'), 0)

1001: ,sysDATE
1002: ,NVL(fnd_profile.value('USER_ID'), 0)
1003: ,sysDATE
1004: ,NVL(fnd_profile.value('USER_ID'), 0)
1005: ,NVL(fnd_profile.value('USER_ID'), 0)
1006: ,PN_SOI_VOL_IMPORT.g_org_id
1007: ,DEDUCTION_ID
1008: ,DEDUCTION_NUM
1009: ,LAST_UPDATE_DATE

Line 1048: ,LAST_UPDATED_BY = NVL(fnd_profile.value('USER_ID'), 0)

1044: WHERE DEDUCTION_ID = v_lines.vol_deduct_id;
1045:
1046: UPDATE PN_VAR_DEDUCTIONS_ALL
1047: SET LAST_UPDATE_DATE = sysDATE
1048: ,LAST_UPDATED_BY = NVL(fnd_profile.value('USER_ID'), 0)
1049: ,LAST_UPDATE_LOGIN = NVL(fnd_profile.value('USER_ID'), 0)
1050: ,LINE_ITEM_ID = v_lines.line_item_id
1051: ,START_DATE = v_lines.rep_str_DATE
1052: ,END_DATE = v_lines.rep_end_DATE

Line 1049: ,LAST_UPDATE_LOGIN = NVL(fnd_profile.value('USER_ID'), 0)

1045:
1046: UPDATE PN_VAR_DEDUCTIONS_ALL
1047: SET LAST_UPDATE_DATE = sysDATE
1048: ,LAST_UPDATED_BY = NVL(fnd_profile.value('USER_ID'), 0)
1049: ,LAST_UPDATE_LOGIN = NVL(fnd_profile.value('USER_ID'), 0)
1050: ,LINE_ITEM_ID = v_lines.line_item_id
1051: ,START_DATE = v_lines.rep_str_DATE
1052: ,END_DATE = v_lines.rep_end_DATE
1053: ,DEDUCTION_TYPE_CODE = v_lines.deduction_type_code