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.

[Home] [Help]

APPS.AP_PMT_CALLOUT_PKG dependencies on FND_PROFILE

Line 33: select decode( nvl(fnd_profile.value('DISPLAY_INVERSE_RATE'),'N'),'N',exchange_rate,

29: begin
30:
31: /* Added decode for bug 11740095 */
32: /* select exchange_rate */
33: select decode( nvl(fnd_profile.value('DISPLAY_INVERSE_RATE'),'N'),'N',exchange_rate,
34: 'Y', 1/exchange_rate)
35: into l_rate
36: from ap_user_exchange_rates
37: where checkrun_id = p_checkrun_id

Line 695: ,P_Last_Updated_By => to_number(FND_PROFILE.VALUE('USER_ID'))

691: ,P_Payment_Num => rec_sel_invs.payment_num
692: ,P_Checkrun_Name => l_Checkrun_Name
693: ,P_Undo_Awt_Date => SYSDATE
694: ,P_Calling_Module => 'CANCEL'
695: ,P_Last_Updated_By => to_number(FND_PROFILE.VALUE('USER_ID'))
696: ,P_Last_Update_Login => to_number(FND_PROFILE.VALUE('LOGIN_ID'))
697: ,P_Program_Application_Id => to_number(FND_PROFILE.VALUE('PROGRAM_APPLICATION_ID'))
698: ,P_Program_Id => to_number(FND_PROFILE.VALUE('PROGRAM_ID'))
699: ,P_Request_Id => to_number(FND_PROFILE.VALUE('REQUEST_ID'))

Line 696: ,P_Last_Update_Login => to_number(FND_PROFILE.VALUE('LOGIN_ID'))

692: ,P_Checkrun_Name => l_Checkrun_Name
693: ,P_Undo_Awt_Date => SYSDATE
694: ,P_Calling_Module => 'CANCEL'
695: ,P_Last_Updated_By => to_number(FND_PROFILE.VALUE('USER_ID'))
696: ,P_Last_Update_Login => to_number(FND_PROFILE.VALUE('LOGIN_ID'))
697: ,P_Program_Application_Id => to_number(FND_PROFILE.VALUE('PROGRAM_APPLICATION_ID'))
698: ,P_Program_Id => to_number(FND_PROFILE.VALUE('PROGRAM_ID'))
699: ,P_Request_Id => to_number(FND_PROFILE.VALUE('REQUEST_ID'))
700: ,P_Awt_Success => undo_output

Line 697: ,P_Program_Application_Id => to_number(FND_PROFILE.VALUE('PROGRAM_APPLICATION_ID'))

693: ,P_Undo_Awt_Date => SYSDATE
694: ,P_Calling_Module => 'CANCEL'
695: ,P_Last_Updated_By => to_number(FND_PROFILE.VALUE('USER_ID'))
696: ,P_Last_Update_Login => to_number(FND_PROFILE.VALUE('LOGIN_ID'))
697: ,P_Program_Application_Id => to_number(FND_PROFILE.VALUE('PROGRAM_APPLICATION_ID'))
698: ,P_Program_Id => to_number(FND_PROFILE.VALUE('PROGRAM_ID'))
699: ,P_Request_Id => to_number(FND_PROFILE.VALUE('REQUEST_ID'))
700: ,P_Awt_Success => undo_output
701: ,P_checkrun_id => l_checkrun_id );

Line 698: ,P_Program_Id => to_number(FND_PROFILE.VALUE('PROGRAM_ID'))

694: ,P_Calling_Module => 'CANCEL'
695: ,P_Last_Updated_By => to_number(FND_PROFILE.VALUE('USER_ID'))
696: ,P_Last_Update_Login => to_number(FND_PROFILE.VALUE('LOGIN_ID'))
697: ,P_Program_Application_Id => to_number(FND_PROFILE.VALUE('PROGRAM_APPLICATION_ID'))
698: ,P_Program_Id => to_number(FND_PROFILE.VALUE('PROGRAM_ID'))
699: ,P_Request_Id => to_number(FND_PROFILE.VALUE('REQUEST_ID'))
700: ,P_Awt_Success => undo_output
701: ,P_checkrun_id => l_checkrun_id );
702: END;

Line 699: ,P_Request_Id => to_number(FND_PROFILE.VALUE('REQUEST_ID'))

695: ,P_Last_Updated_By => to_number(FND_PROFILE.VALUE('USER_ID'))
696: ,P_Last_Update_Login => to_number(FND_PROFILE.VALUE('LOGIN_ID'))
697: ,P_Program_Application_Id => to_number(FND_PROFILE.VALUE('PROGRAM_APPLICATION_ID'))
698: ,P_Program_Id => to_number(FND_PROFILE.VALUE('PROGRAM_ID'))
699: ,P_Request_Id => to_number(FND_PROFILE.VALUE('REQUEST_ID'))
700: ,P_Awt_Success => undo_output
701: ,P_checkrun_id => l_checkrun_id );
702: END;
703: END LOOP;

Line 1188: fnd_profile.get('UNIQUE:SEQ_NUMBERS',l_seq_num_profile);

1184: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1185: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1186: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1187: END IF;
1188: fnd_profile.get('UNIQUE:SEQ_NUMBERS',l_seq_num_profile);
1189: fnd_profile.get('AP_USE_INV_BATCH_CONTROLS', l_batch_control_flag);
1190:
1191: OPEN c_relevant_orgs(l_checkrun_id);
1192:

Line 1189: fnd_profile.get('AP_USE_INV_BATCH_CONTROLS', l_batch_control_flag);

1185: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1186: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1187: END IF;
1188: fnd_profile.get('UNIQUE:SEQ_NUMBERS',l_seq_num_profile);
1189: fnd_profile.get('AP_USE_INV_BATCH_CONTROLS', l_batch_control_flag);
1190:
1191: OPEN c_relevant_orgs(l_checkrun_id);
1192:
1193: l_debug_info := 'c_relevant_orgs';

Line 2002: to_number(FND_PROFILE.VALUE('LOGIN_ID')),

1998: END IF;
1999: AP_WITHHOLDING_PKG.AP_WITHHOLD_CONFIRM(l_checkrun_name,
2000: l_last_updated_by,
2001: --4863216
2002: to_number(FND_PROFILE.VALUE('LOGIN_ID')),
2003: to_number(FND_PROFILE.VALUE('PROGRAM_APPLICATION_ID')),
2004: to_number(FND_PROFILE.VALUE('PROGRAM_ID')),
2005: to_number(FND_PROFILE.VALUE('REQUEST_ID')),
2006: l_checkrun_id,

Line 2003: to_number(FND_PROFILE.VALUE('PROGRAM_APPLICATION_ID')),

1999: AP_WITHHOLDING_PKG.AP_WITHHOLD_CONFIRM(l_checkrun_name,
2000: l_last_updated_by,
2001: --4863216
2002: to_number(FND_PROFILE.VALUE('LOGIN_ID')),
2003: to_number(FND_PROFILE.VALUE('PROGRAM_APPLICATION_ID')),
2004: to_number(FND_PROFILE.VALUE('PROGRAM_ID')),
2005: to_number(FND_PROFILE.VALUE('REQUEST_ID')),
2006: l_checkrun_id,
2007: p_completed_pmts_group_id,

Line 2004: to_number(FND_PROFILE.VALUE('PROGRAM_ID')),

2000: l_last_updated_by,
2001: --4863216
2002: to_number(FND_PROFILE.VALUE('LOGIN_ID')),
2003: to_number(FND_PROFILE.VALUE('PROGRAM_APPLICATION_ID')),
2004: to_number(FND_PROFILE.VALUE('PROGRAM_ID')),
2005: to_number(FND_PROFILE.VALUE('REQUEST_ID')),
2006: l_checkrun_id,
2007: p_completed_pmts_group_id,
2008: l_current_org_id,

Line 2005: to_number(FND_PROFILE.VALUE('REQUEST_ID')),

2001: --4863216
2002: to_number(FND_PROFILE.VALUE('LOGIN_ID')),
2003: to_number(FND_PROFILE.VALUE('PROGRAM_APPLICATION_ID')),
2004: to_number(FND_PROFILE.VALUE('PROGRAM_ID')),
2005: to_number(FND_PROFILE.VALUE('REQUEST_ID')),
2006: l_checkrun_id,
2007: p_completed_pmts_group_id,
2008: l_current_org_id,
2009: l_check_date);

Line 2661: --to_number(FND_PROFILE.VALUE('LOGIN_ID')),

2657: AP_WITHHOLDING_PKG.AP_WITHHOLD_CANCEL(l_checkrun_name,
2658: l_last_updated_by,
2659: --4863216
2660: to_number(FND_GLOBAL.USER_ID),--Bug6489464
2661: --to_number(FND_PROFILE.VALUE('LOGIN_ID')),
2662: to_number(FND_PROFILE.VALUE('PROGRAM_APPLICATION_ID')),
2663: to_number(FND_PROFILE.VALUE('PROGRAM_ID')),
2664: to_number(FND_PROFILE.VALUE('REQUEST_ID')),
2665: l_checkrun_id,

Line 2662: to_number(FND_PROFILE.VALUE('PROGRAM_APPLICATION_ID')),

2658: l_last_updated_by,
2659: --4863216
2660: to_number(FND_GLOBAL.USER_ID),--Bug6489464
2661: --to_number(FND_PROFILE.VALUE('LOGIN_ID')),
2662: to_number(FND_PROFILE.VALUE('PROGRAM_APPLICATION_ID')),
2663: to_number(FND_PROFILE.VALUE('PROGRAM_ID')),
2664: to_number(FND_PROFILE.VALUE('REQUEST_ID')),
2665: l_checkrun_id,
2666: p_completed_pmts_group_id,

Line 2663: to_number(FND_PROFILE.VALUE('PROGRAM_ID')),

2659: --4863216
2660: to_number(FND_GLOBAL.USER_ID),--Bug6489464
2661: --to_number(FND_PROFILE.VALUE('LOGIN_ID')),
2662: to_number(FND_PROFILE.VALUE('PROGRAM_APPLICATION_ID')),
2663: to_number(FND_PROFILE.VALUE('PROGRAM_ID')),
2664: to_number(FND_PROFILE.VALUE('REQUEST_ID')),
2665: l_checkrun_id,
2666: p_completed_pmts_group_id,
2667: l_current_org_id);

Line 2664: to_number(FND_PROFILE.VALUE('REQUEST_ID')),

2660: to_number(FND_GLOBAL.USER_ID),--Bug6489464
2661: --to_number(FND_PROFILE.VALUE('LOGIN_ID')),
2662: to_number(FND_PROFILE.VALUE('PROGRAM_APPLICATION_ID')),
2663: to_number(FND_PROFILE.VALUE('PROGRAM_ID')),
2664: to_number(FND_PROFILE.VALUE('REQUEST_ID')),
2665: l_checkrun_id,
2666: p_completed_pmts_group_id,
2667: l_current_org_id);
2668: