DBA Data[Home] [Help]

APPS.IBY_DISBURSE_UI_API_PUB_PKG dependencies on FND_GLOBAL

Line 2134: last_updated_by = NVL(FND_GLOBAL.user_id,-1),

2130: voided_by = p_voided_by,
2131: void_date = p_void_date,
2132: void_reason = p_void_reason,
2133: last_update_date = sysdate,
2134: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
2135: last_update_login = NVL(FND_GLOBAL.login_id, -1),
2136: positive_pay_file_created_flag = NULL
2137: WHERE
2138: payment_id = p_pmt_id

Line 2135: last_update_login = NVL(FND_GLOBAL.login_id, -1),

2131: void_date = p_void_date,
2132: void_reason = p_void_reason,
2133: last_update_date = sysdate,
2134: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
2135: last_update_login = NVL(FND_GLOBAL.login_id, -1),
2136: positive_pay_file_created_flag = NULL
2137: WHERE
2138: payment_id = p_pmt_id
2139: ;

Line 2158: last_updated_by = NVL(FND_GLOBAL.user_id,-1),

2154: IBY_DOCS_PAYABLE_ALL
2155: SET
2156: document_status = DOC_STATUS_PMT_VOIDED,
2157: last_update_date = sysdate,
2158: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
2159: last_update_login = NVL(FND_GLOBAL.login_id, -1)
2160: WHERE
2161: payment_id = p_pmt_id
2162: ;

Line 2159: last_update_login = NVL(FND_GLOBAL.login_id, -1)

2155: SET
2156: document_status = DOC_STATUS_PMT_VOIDED,
2157: last_update_date = sysdate,
2158: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
2159: last_update_login = NVL(FND_GLOBAL.login_id, -1)
2160: WHERE
2161: payment_id = p_pmt_id
2162: ;
2163:

Line 2258: last_updated_by = NVL(FND_GLOBAL.user_id,-1),

2254: IBY_PAY_INSTRUCTIONS_ALL
2255: SET
2256: payment_instruction_status = INS_STATUS_TERMINATED,
2257: last_update_date = sysdate,
2258: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
2259: last_update_login = NVL(FND_GLOBAL.login_id, -1)
2260: WHERE
2261: payment_instruction_id = l_instr_id
2262: ;

Line 2259: last_update_login = NVL(FND_GLOBAL.login_id, -1)

2255: SET
2256: payment_instruction_status = INS_STATUS_TERMINATED,
2257: last_update_date = sysdate,
2258: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
2259: last_update_login = NVL(FND_GLOBAL.login_id, -1)
2260: WHERE
2261: payment_instruction_id = l_instr_id
2262: ;
2263:

Line 2494: fnd_global.APPS_INITIALIZE(

2490: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2491: print_debuginfo(l_module_name, 'Setting apps context .. ');
2492:
2493: END IF;
2494: fnd_global.APPS_INITIALIZE(
2495: user_id => fnd_global.user_id,
2496: resp_id => fnd_global.resp_id,
2497: resp_appl_id => fnd_global.resp_appl_id
2498: );

Line 2495: user_id => fnd_global.user_id,

2491: print_debuginfo(l_module_name, 'Setting apps context .. ');
2492:
2493: END IF;
2494: fnd_global.APPS_INITIALIZE(
2495: user_id => fnd_global.user_id,
2496: resp_id => fnd_global.resp_id,
2497: resp_appl_id => fnd_global.resp_appl_id
2498: );
2499:

Line 2496: resp_id => fnd_global.resp_id,

2492:
2493: END IF;
2494: fnd_global.APPS_INITIALIZE(
2495: user_id => fnd_global.user_id,
2496: resp_id => fnd_global.resp_id,
2497: resp_appl_id => fnd_global.resp_appl_id
2498: );
2499:
2500: mo_global.init(fnd_global.application_short_name);

Line 2497: resp_appl_id => fnd_global.resp_appl_id

2493: END IF;
2494: fnd_global.APPS_INITIALIZE(
2495: user_id => fnd_global.user_id,
2496: resp_id => fnd_global.resp_id,
2497: resp_appl_id => fnd_global.resp_appl_id
2498: );
2499:
2500: mo_global.init(fnd_global.application_short_name);
2501:

Line 2500: mo_global.init(fnd_global.application_short_name);

2496: resp_id => fnd_global.resp_id,
2497: resp_appl_id => fnd_global.resp_appl_id
2498: );
2499:
2500: mo_global.init(fnd_global.application_short_name);
2501:
2502: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2503: print_debuginfo(l_module_name, 'Apps context set [user: '
2504: || fnd_global.user_id

Line 2504: || fnd_global.user_id

2500: mo_global.init(fnd_global.application_short_name);
2501:
2502: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2503: print_debuginfo(l_module_name, 'Apps context set [user: '
2504: || fnd_global.user_id
2505: || ', responsbility id: '
2506: || fnd_global.resp_id
2507: || ', responsibility application id: '
2508: || fnd_global.resp_appl_id

Line 2506: || fnd_global.resp_id

2502: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2503: print_debuginfo(l_module_name, 'Apps context set [user: '
2504: || fnd_global.user_id
2505: || ', responsbility id: '
2506: || fnd_global.resp_id
2507: || ', responsibility application id: '
2508: || fnd_global.resp_appl_id
2509: || ']'
2510: );

Line 2508: || fnd_global.resp_appl_id

2504: || fnd_global.user_id
2505: || ', responsbility id: '
2506: || fnd_global.resp_id
2507: || ', responsibility application id: '
2508: || fnd_global.resp_appl_id
2509: || ']'
2510: );
2511:
2512: print_debuginfo(l_module_name, 'Apps context [app short name: '

Line 2513: || fnd_global.application_short_name

2509: || ']'
2510: );
2511:
2512: print_debuginfo(l_module_name, 'Apps context [app short name: '
2513: || fnd_global.application_short_name
2514: || ']'
2515: );
2516:
2517: END IF;

Line 2695: last_updated_by = NVL(FND_GLOBAL.user_id,-1),

2691: voided_by = p_voided_by,
2692: void_date = p_void_date,
2693: void_reason = p_void_reason,
2694: last_update_date = sysdate, --Bug 13999452
2695: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
2696: last_update_login = NVL(FND_GLOBAL.login_id, -1),
2697: positive_pay_file_created_flag = NULL
2698: WHERE
2699: payment_id = p_pmt_id

Line 2696: last_update_login = NVL(FND_GLOBAL.login_id, -1),

2692: void_date = p_void_date,
2693: void_reason = p_void_reason,
2694: last_update_date = sysdate, --Bug 13999452
2695: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
2696: last_update_login = NVL(FND_GLOBAL.login_id, -1),
2697: positive_pay_file_created_flag = NULL
2698: WHERE
2699: payment_id = p_pmt_id
2700: ;

Line 2712: last_updated_by = NVL(FND_GLOBAL.user_id,-1),

2708: IBY_DOCS_PAYABLE_ALL
2709: SET
2710: document_status = DOC_STATUS_PMT_VOIDED,
2711: last_update_date = sysdate,
2712: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
2713: last_update_login = NVL(FND_GLOBAL.login_id, -1)
2714: WHERE
2715: payment_id = p_pmt_id
2716: ;

Line 2713: last_update_login = NVL(FND_GLOBAL.login_id, -1)

2709: SET
2710: document_status = DOC_STATUS_PMT_VOIDED,
2711: last_update_date = sysdate,
2712: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
2713: last_update_login = NVL(FND_GLOBAL.login_id, -1)
2714: WHERE
2715: payment_id = p_pmt_id
2716: ;
2717:

Line 2804: last_updated_by = NVL(FND_GLOBAL.user_id,-1),

2800: IBY_PAY_INSTRUCTIONS_ALL
2801: SET
2802: payment_instruction_status = INS_STATUS_TERMINATED,
2803: last_update_date = sysdate,
2804: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
2805: last_update_login = NVL(FND_GLOBAL.login_id, -1)
2806: WHERE
2807: payment_instruction_id = l_instr_id
2808: ;

Line 2805: last_update_login = NVL(FND_GLOBAL.login_id, -1)

2801: SET
2802: payment_instruction_status = INS_STATUS_TERMINATED,
2803: last_update_date = sysdate,
2804: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
2805: last_update_login = NVL(FND_GLOBAL.login_id, -1)
2806: WHERE
2807: payment_instruction_id = l_instr_id
2808: ;
2809:

Line 3536: last_updated_by = NVL(FND_GLOBAL.user_id,-1),

3532: iby_pay_instructions_all
3533: SET
3534: payment_instruction_status = INS_STATUS_TERMINATED,
3535: last_update_date = sysdate,
3536: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
3537: last_update_login = NVL(FND_GLOBAL.login_id, -1)
3538: WHERE
3539: payment_instruction_id = p_instr_id
3540: ;

Line 3537: last_update_login = NVL(FND_GLOBAL.login_id, -1)

3533: SET
3534: payment_instruction_status = INS_STATUS_TERMINATED,
3535: last_update_date = sysdate,
3536: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
3537: last_update_login = NVL(FND_GLOBAL.login_id, -1)
3538: WHERE
3539: payment_instruction_id = p_instr_id
3540: ;
3541:

Line 5609: LAST_UPDATED_BY = NVL(FND_GLOBAL.user_id,-1),

5605: iby_pay_service_requests
5606: SET
5607: payment_service_request_status = REQ_STATUS_TERMINATED,
5608: last_update_date = sysdate,
5609: LAST_UPDATED_BY = NVL(FND_GLOBAL.user_id,-1),
5610: LAST_UPDATE_LOGIN = NVL(FND_GLOBAL.login_id, -1)
5611: WHERE
5612: payment_service_request_id = p_req_id
5613: ;

Line 5610: LAST_UPDATE_LOGIN = NVL(FND_GLOBAL.login_id, -1)

5606: SET
5607: payment_service_request_status = REQ_STATUS_TERMINATED,
5608: last_update_date = sysdate,
5609: LAST_UPDATED_BY = NVL(FND_GLOBAL.user_id,-1),
5610: LAST_UPDATE_LOGIN = NVL(FND_GLOBAL.login_id, -1)
5611: WHERE
5612: payment_service_request_id = p_req_id
5613: ;
5614: Select count(1) --Bug 14335525

Line 6641: fnd_global.user_id,

6637: p_pmt_doc_id,
6638: p_old_ppr_docs_list(i),
6639: sysdate,
6640: DOC_USE_SPOILED,
6641: fnd_global.user_id,
6642: sysdate,
6643: fnd_global.user_id,
6644: sysdate,
6645: fnd_global.login_id,

Line 6643: fnd_global.user_id,

6639: sysdate,
6640: DOC_USE_SPOILED,
6641: fnd_global.user_id,
6642: sysdate,
6643: fnd_global.user_id,
6644: sysdate,
6645: fnd_global.login_id,
6646: 1
6647: );

Line 6645: fnd_global.login_id,

6641: fnd_global.user_id,
6642: sysdate,
6643: fnd_global.user_id,
6644: sysdate,
6645: fnd_global.login_id,
6646: 1
6647: );
6648:
6649: END LOOP;

Line 8245: fnd_global.user_id,

8241: p_pmt_doc_id,
8242: l_skipped_docs_list(i),
8243: sysdate,
8244: 'SKIPPED',
8245: fnd_global.user_id,
8246: sysdate,
8247: fnd_global.user_id,
8248: sysdate,
8249: fnd_global.login_id,

Line 8247: fnd_global.user_id,

8243: sysdate,
8244: 'SKIPPED',
8245: fnd_global.user_id,
8246: sysdate,
8247: fnd_global.user_id,
8248: sysdate,
8249: fnd_global.login_id,
8250: 1
8251: );

Line 8249: fnd_global.login_id,

8245: fnd_global.user_id,
8246: sysdate,
8247: fnd_global.user_id,
8248: sysdate,
8249: fnd_global.login_id,
8250: 1
8251: );
8252: END;
8253:

Line 8391: fnd_global.user_id,

8387: p_pmt_doc_id,
8388: l_used_docs_list(i),
8389: sysdate,
8390: decode(l_payment_status_list(i),'REMOVED_DOCUMENT_SPOILED','SPOILED','ISSUED'),
8391: fnd_global.user_id,
8392: sysdate,
8393: fnd_global.user_id,
8394: sysdate,
8395: fnd_global.login_id,

Line 8393: fnd_global.user_id,

8389: sysdate,
8390: decode(l_payment_status_list(i),'REMOVED_DOCUMENT_SPOILED','SPOILED','ISSUED'),
8391: fnd_global.user_id,
8392: sysdate,
8393: fnd_global.user_id,
8394: sysdate,
8395: fnd_global.login_id,
8396: 1
8397: );

Line 8395: fnd_global.login_id,

8391: fnd_global.user_id,
8392: sysdate,
8393: fnd_global.user_id,
8394: sysdate,
8395: fnd_global.login_id,
8396: 1
8397: );
8398:
8399: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 9086: fnd_global.APPS_INITIALIZE(

9082: /*IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
9083: print_debuginfo(l_module_name, 'Setting apps context .. ');
9084: END IF;
9085:
9086: fnd_global.APPS_INITIALIZE(
9087: user_id => fnd_global.user_id,
9088: resp_id => fnd_global.resp_id,
9089: resp_appl_id => fnd_global.resp_appl_id
9090: );

Line 9087: user_id => fnd_global.user_id,

9083: print_debuginfo(l_module_name, 'Setting apps context .. ');
9084: END IF;
9085:
9086: fnd_global.APPS_INITIALIZE(
9087: user_id => fnd_global.user_id,
9088: resp_id => fnd_global.resp_id,
9089: resp_appl_id => fnd_global.resp_appl_id
9090: );
9091:

Line 9088: resp_id => fnd_global.resp_id,

9084: END IF;
9085:
9086: fnd_global.APPS_INITIALIZE(
9087: user_id => fnd_global.user_id,
9088: resp_id => fnd_global.resp_id,
9089: resp_appl_id => fnd_global.resp_appl_id
9090: );
9091:
9092: mo_global.init(fnd_global.application_short_name);

Line 9089: resp_appl_id => fnd_global.resp_appl_id

9085:
9086: fnd_global.APPS_INITIALIZE(
9087: user_id => fnd_global.user_id,
9088: resp_id => fnd_global.resp_id,
9089: resp_appl_id => fnd_global.resp_appl_id
9090: );
9091:
9092: mo_global.init(fnd_global.application_short_name);
9093:

Line 9092: mo_global.init(fnd_global.application_short_name);

9088: resp_id => fnd_global.resp_id,
9089: resp_appl_id => fnd_global.resp_appl_id
9090: );
9091:
9092: mo_global.init(fnd_global.application_short_name);
9093:
9094: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
9095: print_debuginfo(l_module_name, 'Apps context set [user: '
9096: || fnd_global.user_id

Line 9096: || fnd_global.user_id

9092: mo_global.init(fnd_global.application_short_name);
9093:
9094: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
9095: print_debuginfo(l_module_name, 'Apps context set [user: '
9096: || fnd_global.user_id
9097: || ', responsbility id: '
9098: || fnd_global.resp_id
9099: || ', responsibility application id: '
9100: || fnd_global.resp_appl_id

Line 9098: || fnd_global.resp_id

9094: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
9095: print_debuginfo(l_module_name, 'Apps context set [user: '
9096: || fnd_global.user_id
9097: || ', responsbility id: '
9098: || fnd_global.resp_id
9099: || ', responsibility application id: '
9100: || fnd_global.resp_appl_id
9101: || ']'
9102: );

Line 9100: || fnd_global.resp_appl_id

9096: || fnd_global.user_id
9097: || ', responsbility id: '
9098: || fnd_global.resp_id
9099: || ', responsibility application id: '
9100: || fnd_global.resp_appl_id
9101: || ']'
9102: );
9103:
9104: print_debuginfo(l_module_name, 'Apps context [app short name: '

Line 9105: || fnd_global.application_short_name

9101: || ']'
9102: );
9103:
9104: print_debuginfo(l_module_name, 'Apps context [app short name: '
9105: || fnd_global.application_short_name
9106: || ']'
9107: );
9108: END IF;*/
9109:

Line 9766: LAST_UPDATED_BY = NVL(FND_GLOBAL.user_id,-1),

9762: END IF;
9763: update iby_pay_service_requests
9764: set payment_service_request_status = REQ_STATUS_COMPLETED,
9765: last_update_date = sysdate,
9766: LAST_UPDATED_BY = NVL(FND_GLOBAL.user_id,-1),
9767: LAST_UPDATE_LOGIN = NVL(FND_GLOBAL.login_id, -1)
9768: where payment_service_request_id = l_pprIdsTab(i);
9769: end if;
9770:

Line 9767: LAST_UPDATE_LOGIN = NVL(FND_GLOBAL.login_id, -1)

9763: update iby_pay_service_requests
9764: set payment_service_request_status = REQ_STATUS_COMPLETED,
9765: last_update_date = sysdate,
9766: LAST_UPDATED_BY = NVL(FND_GLOBAL.user_id,-1),
9767: LAST_UPDATE_LOGIN = NVL(FND_GLOBAL.login_id, -1)
9768: where payment_service_request_id = l_pprIdsTab(i);
9769: end if;
9770:
9771: END LOOP;

Line 9834: fnd_global.user_id CREATED_BY,

9830: (SELECT l_pmt_doc_id PAYMENT_DOCUMENT_ID,
9831: paper_document_number USED_DOCUMENT_NUMBER,
9832: sysdate DATE_USED,
9833: PAY_STATUS_ISSUED DOCUMENT_USE,
9834: fnd_global.user_id CREATED_BY,
9835: sysdate CREATION_DATE,
9836: fnd_global.user_id LAST_UPDATED_BY,
9837: sysdate LAST_UPDATE_DATE,
9838: fnd_global.login_id LAST_UPDATE_LOGIN,

Line 9836: fnd_global.user_id LAST_UPDATED_BY,

9832: sysdate DATE_USED,
9833: PAY_STATUS_ISSUED DOCUMENT_USE,
9834: fnd_global.user_id CREATED_BY,
9835: sysdate CREATION_DATE,
9836: fnd_global.user_id LAST_UPDATED_BY,
9837: sysdate LAST_UPDATE_DATE,
9838: fnd_global.login_id LAST_UPDATE_LOGIN,
9839: 1 OBJECT_VERSION_NUMBER
9840: FROM iby_payments_all

Line 9838: fnd_global.login_id LAST_UPDATE_LOGIN,

9834: fnd_global.user_id CREATED_BY,
9835: sysdate CREATION_DATE,
9836: fnd_global.user_id LAST_UPDATED_BY,
9837: sysdate LAST_UPDATE_DATE,
9838: fnd_global.login_id LAST_UPDATE_LOGIN,
9839: 1 OBJECT_VERSION_NUMBER
9840: FROM iby_payments_all
9841: WHERE payment_instruction_id = p_instr_id AND
9842: payment_status = PAY_STATUS_FORMATTED AND paper_document_number is not null);

Line 11234: fnd_global.user_id, /* 5 */

11230: p_object_id, /* 1 */
11231: p_object_type,
11232: p_conc_request_id,
11233: p_completed_flag,
11234: fnd_global.user_id, /* 5 */
11235: sysdate,
11236: fnd_global.user_id,
11237: sysdate,
11238: fnd_global.login_id,

Line 11236: fnd_global.user_id,

11232: p_conc_request_id,
11233: p_completed_flag,
11234: fnd_global.user_id, /* 5 */
11235: sysdate,
11236: fnd_global.user_id,
11237: sysdate,
11238: fnd_global.login_id,
11239: 1 /* 10 */
11240: )

Line 11238: fnd_global.login_id,

11234: fnd_global.user_id, /* 5 */
11235: sysdate,
11236: fnd_global.user_id,
11237: sysdate,
11238: fnd_global.login_id,
11239: 1 /* 10 */
11240: )
11241: ;
11242: END IF;

Line 11308: | FND_GLOBAL.CONC_REQUEST_ID will be used.

11304: | PAYMENT_INSTRUCTION
11305: |
11306: | p_conc_request_id The concurrent request id to stamp the payment
11307: | entity with. If NULL is provided, the value of
11308: | FND_GLOBAL.CONC_REQUEST_ID will be used.
11309: |
11310: | OUT
11311: | x_return_status Return status (S, E, U)
11312: |

Line 11366: l_conc_request_id := FND_GLOBAL.conc_request_id;

11362: || 'provided. Deriving from context ..'
11363: );
11364:
11365: END IF;
11366: l_conc_request_id := FND_GLOBAL.conc_request_id;
11367:
11368: ELSE
11369:
11370: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 11393: LAST_UPDATED_BY = NVL(FND_GLOBAL.user_id,-1),

11389: IBY_PAY_SERVICE_REQUESTS req
11390: SET
11391: req.request_id = l_conc_request_id,
11392: last_update_date = sysdate,
11393: LAST_UPDATED_BY = NVL(FND_GLOBAL.user_id,-1),
11394: LAST_UPDATE_LOGIN = NVL(FND_GLOBAL.login_id, -1)
11395: WHERE
11396: req.payment_service_request_id = p_object_id
11397: ;

Line 11394: LAST_UPDATE_LOGIN = NVL(FND_GLOBAL.login_id, -1)

11390: SET
11391: req.request_id = l_conc_request_id,
11392: last_update_date = sysdate,
11393: LAST_UPDATED_BY = NVL(FND_GLOBAL.user_id,-1),
11394: LAST_UPDATE_LOGIN = NVL(FND_GLOBAL.login_id, -1)
11395: WHERE
11396: req.payment_service_request_id = p_object_id
11397: ;
11398:

Line 11622: LAST_UPDATED_BY = NVL(FND_GLOBAL.user_id,-1),

11618: IBY_PAY_SERVICE_REQUESTS req
11619: SET
11620: req.request_id = NULL,
11621: last_update_date = sysdate,
11622: LAST_UPDATED_BY = NVL(FND_GLOBAL.user_id,-1),
11623: LAST_UPDATE_LOGIN = NVL(FND_GLOBAL.login_id, -1)
11624: WHERE
11625: req.payment_service_request_id = p_object_id
11626: ;

Line 11623: LAST_UPDATE_LOGIN = NVL(FND_GLOBAL.login_id, -1)

11619: SET
11620: req.request_id = NULL,
11621: last_update_date = sysdate,
11622: LAST_UPDATED_BY = NVL(FND_GLOBAL.user_id,-1),
11623: LAST_UPDATE_LOGIN = NVL(FND_GLOBAL.login_id, -1)
11624: WHERE
11625: req.payment_service_request_id = p_object_id
11626: ;
11627:

Line 11770: fnd_global.user_name);

11766: null,
11767: null,
11768: null,
11769: null,
11770: fnd_global.user_name);
11771:
11772: if(l_bool) then
11773: --print_debuginfo(l_module_name, 'User has access to:' || l_func);
11774: insert into IBY_USER_PAY_FUNS_GT(payment_function)