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.OZF_SD_REQUEST_PUB dependencies on FND_GLOBAL

Line 2197: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)

2193: OZF_SD_REQUEST_HEADER_PKG.Insert_Row(
2194: p_request_header_id =>l_req_hdr_seq
2195: ,p_object_version_number =>1
2196: ,p_last_update_date =>SYSDATE
2197: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
2198: ,p_creation_date =>SYSDATE
2199: ,p_created_by =>NVL(FND_GLOBAL.user_id,-1)
2200: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
2201: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID

Line 2199: ,p_created_by =>NVL(FND_GLOBAL.user_id,-1)

2195: ,p_object_version_number =>1
2196: ,p_last_update_date =>SYSDATE
2197: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
2198: ,p_creation_date =>SYSDATE
2199: ,p_created_by =>NVL(FND_GLOBAL.user_id,-1)
2200: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
2201: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID
2202: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID
2203: ,p_program_update_date =>SYSDATE

Line 2200: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)

2196: ,p_last_update_date =>SYSDATE
2197: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
2198: ,p_creation_date =>SYSDATE
2199: ,p_created_by =>NVL(FND_GLOBAL.user_id,-1)
2200: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
2201: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID
2202: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID
2203: ,p_program_update_date =>SYSDATE
2204: ,p_program_id =>FND_GLOBAL.CONC_PROGRAM_ID

Line 2201: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID

2197: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
2198: ,p_creation_date =>SYSDATE
2199: ,p_created_by =>NVL(FND_GLOBAL.user_id,-1)
2200: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
2201: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID
2202: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID
2203: ,p_program_update_date =>SYSDATE
2204: ,p_program_id =>FND_GLOBAL.CONC_PROGRAM_ID
2205: ,p_created_from =>NULL

Line 2202: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID

2198: ,p_creation_date =>SYSDATE
2199: ,p_created_by =>NVL(FND_GLOBAL.user_id,-1)
2200: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
2201: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID
2202: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID
2203: ,p_program_update_date =>SYSDATE
2204: ,p_program_id =>FND_GLOBAL.CONC_PROGRAM_ID
2205: ,p_created_from =>NULL
2206: ,p_request_number =>l_SDR_hdr_rec.request_number

Line 2204: ,p_program_id =>FND_GLOBAL.CONC_PROGRAM_ID

2200: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
2201: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID
2202: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID
2203: ,p_program_update_date =>SYSDATE
2204: ,p_program_id =>FND_GLOBAL.CONC_PROGRAM_ID
2205: ,p_created_from =>NULL
2206: ,p_request_number =>l_SDR_hdr_rec.request_number
2207: ,p_request_class =>l_request_class
2208: ,p_offer_type =>NULL

Line 2316: NVL(FND_GLOBAL.user_id,-1),

2312: org_id)
2313: SELECT
2314: p_request_header_id,
2315: SYSDATE,
2316: NVL(FND_GLOBAL.user_id,-1),
2317: SYSDATE,
2318: NVL(FND_GLOBAL.user_id,-1),
2319: NVL(FND_GLOBAL.conc_login_id,-1),
2320: p_description,

Line 2318: NVL(FND_GLOBAL.user_id,-1),

2314: p_request_header_id,
2315: SYSDATE,
2316: NVL(FND_GLOBAL.user_id,-1),
2317: SYSDATE,
2318: NVL(FND_GLOBAL.user_id,-1),
2319: NVL(FND_GLOBAL.conc_login_id,-1),
2320: p_description,
2321: l.language_code,
2322: USERENV('LANG'),

Line 2319: NVL(FND_GLOBAL.conc_login_id,-1),

2315: SYSDATE,
2316: NVL(FND_GLOBAL.user_id,-1),
2317: SYSDATE,
2318: NVL(FND_GLOBAL.user_id,-1),
2319: NVL(FND_GLOBAL.conc_login_id,-1),
2320: p_description,
2321: l.language_code,
2322: USERENV('LANG'),
2323: FND_GLOBAL.CONC_REQUEST_ID,

Line 2323: FND_GLOBAL.CONC_REQUEST_ID,

2319: NVL(FND_GLOBAL.conc_login_id,-1),
2320: p_description,
2321: l.language_code,
2322: USERENV('LANG'),
2323: FND_GLOBAL.CONC_REQUEST_ID,
2324: FND_GLOBAL.PROG_APPL_ID,
2325: SYSDATE,
2326: FND_GLOBAL.CONC_PROGRAM_ID,
2327: NULL,

Line 2324: FND_GLOBAL.PROG_APPL_ID,

2320: p_description,
2321: l.language_code,
2322: USERENV('LANG'),
2323: FND_GLOBAL.CONC_REQUEST_ID,
2324: FND_GLOBAL.PROG_APPL_ID,
2325: SYSDATE,
2326: FND_GLOBAL.CONC_PROGRAM_ID,
2327: NULL,
2328: NULL,

Line 2326: FND_GLOBAL.CONC_PROGRAM_ID,

2322: USERENV('LANG'),
2323: FND_GLOBAL.CONC_REQUEST_ID,
2324: FND_GLOBAL.PROG_APPL_ID,
2325: SYSDATE,
2326: FND_GLOBAL.CONC_PROGRAM_ID,
2327: NULL,
2328: NULL,
2329: p_org_id
2330: FROM fnd_languages l

Line 2402: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)

2398: OZF_SD_REQUEST_LINES_PKG.Insert_Row(
2399: p_request_line_id =>l_req_line_seq
2400: ,p_object_version_number =>1
2401: ,p_last_update_date =>SYSDATE
2402: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
2403: ,p_creation_date =>SYSDATE
2404: ,p_created_by =>NVL(FND_GLOBAL.user_id,-1)
2405: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
2406: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID

Line 2404: ,p_created_by =>NVL(FND_GLOBAL.user_id,-1)

2400: ,p_object_version_number =>1
2401: ,p_last_update_date =>SYSDATE
2402: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
2403: ,p_creation_date =>SYSDATE
2404: ,p_created_by =>NVL(FND_GLOBAL.user_id,-1)
2405: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
2406: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID
2407: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID
2408: ,p_program_update_date =>SYSDATE

Line 2405: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)

2401: ,p_last_update_date =>SYSDATE
2402: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
2403: ,p_creation_date =>SYSDATE
2404: ,p_created_by =>NVL(FND_GLOBAL.user_id,-1)
2405: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
2406: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID
2407: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID
2408: ,p_program_update_date =>SYSDATE
2409: ,p_program_id =>FND_GLOBAL.CONC_PROGRAM_ID

Line 2406: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID

2402: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
2403: ,p_creation_date =>SYSDATE
2404: ,p_created_by =>NVL(FND_GLOBAL.user_id,-1)
2405: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
2406: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID
2407: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID
2408: ,p_program_update_date =>SYSDATE
2409: ,p_program_id =>FND_GLOBAL.CONC_PROGRAM_ID
2410: ,p_create_from =>NULL

Line 2407: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID

2403: ,p_creation_date =>SYSDATE
2404: ,p_created_by =>NVL(FND_GLOBAL.user_id,-1)
2405: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
2406: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID
2407: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID
2408: ,p_program_update_date =>SYSDATE
2409: ,p_program_id =>FND_GLOBAL.CONC_PROGRAM_ID
2410: ,p_create_from =>NULL
2411: ,p_request_header_id =>p_request_header_id

Line 2409: ,p_program_id =>FND_GLOBAL.CONC_PROGRAM_ID

2405: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
2406: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID
2407: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID
2408: ,p_program_update_date =>SYSDATE
2409: ,p_program_id =>FND_GLOBAL.CONC_PROGRAM_ID
2410: ,p_create_from =>NULL
2411: ,p_request_header_id =>p_request_header_id
2412: ,p_product_context =>p_SDR_lines_tbl(p).product_context
2413: ,p_inventory_item_id =>p_SDR_lines_tbl(p).inventory_item_id

Line 2468: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)

2464: OZF_SD_REQUEST_LINES_PKG.Update_Row(
2465: p_request_line_id =>p_SDR_lines_tbl(p).request_line_id
2466: ,p_object_version_number =>p_SDR_lines_tbl(p).object_version_number + 1
2467: ,p_last_update_date =>SYSDATE
2468: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
2469: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
2470: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID
2471: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID
2472: ,p_program_update_date =>SYSDATE

Line 2469: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)

2465: p_request_line_id =>p_SDR_lines_tbl(p).request_line_id
2466: ,p_object_version_number =>p_SDR_lines_tbl(p).object_version_number + 1
2467: ,p_last_update_date =>SYSDATE
2468: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
2469: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
2470: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID
2471: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID
2472: ,p_program_update_date =>SYSDATE
2473: ,p_program_id =>FND_GLOBAL.CONC_PROGRAM_ID

Line 2470: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID

2466: ,p_object_version_number =>p_SDR_lines_tbl(p).object_version_number + 1
2467: ,p_last_update_date =>SYSDATE
2468: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
2469: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
2470: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID
2471: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID
2472: ,p_program_update_date =>SYSDATE
2473: ,p_program_id =>FND_GLOBAL.CONC_PROGRAM_ID
2474: ,p_create_from =>NULL

Line 2471: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID

2467: ,p_last_update_date =>SYSDATE
2468: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
2469: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
2470: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID
2471: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID
2472: ,p_program_update_date =>SYSDATE
2473: ,p_program_id =>FND_GLOBAL.CONC_PROGRAM_ID
2474: ,p_create_from =>NULL
2475: ,p_request_header_id =>p_request_header_id

Line 2473: ,p_program_id =>FND_GLOBAL.CONC_PROGRAM_ID

2469: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
2470: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID
2471: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID
2472: ,p_program_update_date =>SYSDATE
2473: ,p_program_id =>FND_GLOBAL.CONC_PROGRAM_ID
2474: ,p_create_from =>NULL
2475: ,p_request_header_id =>p_request_header_id
2476: ,p_product_context =>p_SDR_lines_tbl(p).product_context
2477: ,p_inventory_item_id =>p_SDR_lines_tbl(p).inventory_item_id

Line 2632: ,p_created_by =>NVL(FND_GLOBAL.user_id,-1)

2628: ,p_site_use_id =>p_SDR_cust_tbl(c).site_use_id
2629: ,p_cust_usage_code =>p_SDR_cust_tbl(c).cust_usage_code
2630: ,p_security_group_id =>NULL
2631: ,p_creation_date =>SYSDATE
2632: ,p_created_by =>NVL(FND_GLOBAL.user_id,-1)
2633: ,p_last_update_date =>SYSDATE
2634: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
2635: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
2636: ,p_object_version_number =>1

Line 2634: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)

2630: ,p_security_group_id =>NULL
2631: ,p_creation_date =>SYSDATE
2632: ,p_created_by =>NVL(FND_GLOBAL.user_id,-1)
2633: ,p_last_update_date =>SYSDATE
2634: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
2635: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
2636: ,p_object_version_number =>1
2637: ,p_attribute_category =>p_SDR_cust_tbl(c).attribute_category
2638: ,p_attribute1 =>p_SDR_cust_tbl(c).attribute1

Line 2635: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)

2631: ,p_creation_date =>SYSDATE
2632: ,p_created_by =>NVL(FND_GLOBAL.user_id,-1)
2633: ,p_last_update_date =>SYSDATE
2634: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
2635: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
2636: ,p_object_version_number =>1
2637: ,p_attribute_category =>p_SDR_cust_tbl(c).attribute_category
2638: ,p_attribute1 =>p_SDR_cust_tbl(c).attribute1
2639: ,p_attribute2 =>p_SDR_cust_tbl(c).attribute2

Line 2664: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)

2660: ,p_site_use_id =>p_SDR_cust_tbl(c).site_use_id
2661: ,p_cust_usage_code =>p_SDR_cust_tbl(c).cust_usage_code
2662: ,p_security_group_id =>NULL
2663: ,p_last_update_date =>SYSDATE
2664: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
2665: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
2666: ,p_object_version_number =>p_SDR_cust_tbl(c).object_version_number + 1
2667: ,p_attribute_category =>p_SDR_cust_tbl(c).attribute_category
2668: ,p_attribute1 =>p_SDR_cust_tbl(c).attribute1

Line 2665: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)

2661: ,p_cust_usage_code =>p_SDR_cust_tbl(c).cust_usage_code
2662: ,p_security_group_id =>NULL
2663: ,p_last_update_date =>SYSDATE
2664: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
2665: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
2666: ,p_object_version_number =>p_SDR_cust_tbl(c).object_version_number + 1
2667: ,p_attribute_category =>p_SDR_cust_tbl(c).attribute_category
2668: ,p_attribute1 =>p_SDR_cust_tbl(c).attribute1
2669: ,p_attribute2 =>p_SDR_cust_tbl(c).attribute2

Line 2750: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)

2746: OZF_SD_REQUEST_HEADER_PKG.Update_Row(
2747: p_request_header_id =>p_SDR_hdr_rec.request_header_id
2748: ,p_object_version_number =>p_SDR_hdr_rec.object_version_number + 1
2749: ,p_last_update_date =>SYSDATE
2750: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
2751: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
2752: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID
2753: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID
2754: ,p_program_update_date =>SYSDATE

Line 2751: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)

2747: p_request_header_id =>p_SDR_hdr_rec.request_header_id
2748: ,p_object_version_number =>p_SDR_hdr_rec.object_version_number + 1
2749: ,p_last_update_date =>SYSDATE
2750: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
2751: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
2752: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID
2753: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID
2754: ,p_program_update_date =>SYSDATE
2755: ,p_program_id =>FND_GLOBAL.CONC_PROGRAM_ID

Line 2752: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID

2748: ,p_object_version_number =>p_SDR_hdr_rec.object_version_number + 1
2749: ,p_last_update_date =>SYSDATE
2750: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
2751: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
2752: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID
2753: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID
2754: ,p_program_update_date =>SYSDATE
2755: ,p_program_id =>FND_GLOBAL.CONC_PROGRAM_ID
2756: ,p_created_from =>NULL

Line 2753: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID

2749: ,p_last_update_date =>SYSDATE
2750: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
2751: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
2752: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID
2753: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID
2754: ,p_program_update_date =>SYSDATE
2755: ,p_program_id =>FND_GLOBAL.CONC_PROGRAM_ID
2756: ,p_created_from =>NULL
2757: ,p_request_number =>p_SDR_hdr_rec.request_number

Line 2755: ,p_program_id =>FND_GLOBAL.CONC_PROGRAM_ID

2751: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
2752: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID
2753: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID
2754: ,p_program_update_date =>SYSDATE
2755: ,p_program_id =>FND_GLOBAL.CONC_PROGRAM_ID
2756: ,p_created_from =>NULL
2757: ,p_request_number =>p_SDR_hdr_rec.request_number
2758: ,p_request_class =>'SD_REQUEST'
2759: ,p_offer_type =>l_offer_type

Line 4614: l_user_id := FND_GLOBAL.user_id;

4610: x_return_status := FND_API.G_RET_STS_SUCCESS;
4611: --==============================================================================
4612: --//Bug 7190421 - User Check and population
4613:
4614: l_user_id := FND_GLOBAL.user_id;
4615:
4616: IF G_DEBUG THEN
4617: OZF_UTILITY_PVT.debug_message('l_user_id: ' ||l_user_id);
4618: END IF;