APPS.OZF_SD_REQUEST_PUB dependencies on FND_GLOBAL

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

2724: OZF_SD_REQUEST_HEADER_PKG.Insert_Row(
2725: p_request_header_id =>l_req_hdr_seq
2726: ,p_object_version_number =>1
2727: ,p_last_update_date =>SYSDATE
2728: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
2729: ,p_creation_date =>SYSDATE
2730: ,p_created_by =>NVL(FND_GLOBAL.user_id,-1)
2731: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
2732: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID

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

2726: ,p_object_version_number =>1
2727: ,p_last_update_date =>SYSDATE
2728: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
2729: ,p_creation_date =>SYSDATE
2730: ,p_created_by =>NVL(FND_GLOBAL.user_id,-1)
2731: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
2732: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID
2733: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID
2734: ,p_program_update_date =>SYSDATE

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

2727: ,p_last_update_date =>SYSDATE
2728: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
2729: ,p_creation_date =>SYSDATE
2730: ,p_created_by =>NVL(FND_GLOBAL.user_id,-1)
2731: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
2732: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID
2733: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID
2734: ,p_program_update_date =>SYSDATE
2735: ,p_program_id =>FND_GLOBAL.CONC_PROGRAM_ID

Line 2732: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID

2728: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
2729: ,p_creation_date =>SYSDATE
2730: ,p_created_by =>NVL(FND_GLOBAL.user_id,-1)
2731: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
2732: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID
2733: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID
2734: ,p_program_update_date =>SYSDATE
2735: ,p_program_id =>FND_GLOBAL.CONC_PROGRAM_ID
2736: ,p_created_from =>NULL

Line 2733: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID

2729: ,p_creation_date =>SYSDATE
2730: ,p_created_by =>NVL(FND_GLOBAL.user_id,-1)
2731: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
2732: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID
2733: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID
2734: ,p_program_update_date =>SYSDATE
2735: ,p_program_id =>FND_GLOBAL.CONC_PROGRAM_ID
2736: ,p_created_from =>NULL
2737: ,p_request_number =>l_SDR_hdr_rec.request_number

Line 2735: ,p_program_id =>FND_GLOBAL.CONC_PROGRAM_ID

2731: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
2732: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID
2733: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID
2734: ,p_program_update_date =>SYSDATE
2735: ,p_program_id =>FND_GLOBAL.CONC_PROGRAM_ID
2736: ,p_created_from =>NULL
2737: ,p_request_number =>l_SDR_hdr_rec.request_number
2738: ,p_request_class =>l_request_class
2739: ,p_offer_type =>NULL

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

2843: org_id)
2844: SELECT
2845: p_request_header_id,
2846: SYSDATE,
2847: NVL(FND_GLOBAL.user_id,-1),
2848: SYSDATE,
2849: NVL(FND_GLOBAL.user_id,-1),
2850: NVL(FND_GLOBAL.conc_login_id,-1),
2851: p_description,

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

2845: p_request_header_id,
2846: SYSDATE,
2847: NVL(FND_GLOBAL.user_id,-1),
2848: SYSDATE,
2849: NVL(FND_GLOBAL.user_id,-1),
2850: NVL(FND_GLOBAL.conc_login_id,-1),
2851: p_description,
2852: l.language_code,
2853: USERENV('LANG'),

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

2846: SYSDATE,
2847: NVL(FND_GLOBAL.user_id,-1),
2848: SYSDATE,
2849: NVL(FND_GLOBAL.user_id,-1),
2850: NVL(FND_GLOBAL.conc_login_id,-1),
2851: p_description,
2852: l.language_code,
2853: USERENV('LANG'),
2854: FND_GLOBAL.CONC_REQUEST_ID,

Line 2854: FND_GLOBAL.CONC_REQUEST_ID,

2850: NVL(FND_GLOBAL.conc_login_id,-1),
2851: p_description,
2852: l.language_code,
2853: USERENV('LANG'),
2854: FND_GLOBAL.CONC_REQUEST_ID,
2855: FND_GLOBAL.PROG_APPL_ID,
2856: SYSDATE,
2857: FND_GLOBAL.CONC_PROGRAM_ID,
2858: NULL,

Line 2855: FND_GLOBAL.PROG_APPL_ID,

2851: p_description,
2852: l.language_code,
2853: USERENV('LANG'),
2854: FND_GLOBAL.CONC_REQUEST_ID,
2855: FND_GLOBAL.PROG_APPL_ID,
2856: SYSDATE,
2857: FND_GLOBAL.CONC_PROGRAM_ID,
2858: NULL,
2859: NULL,

Line 2857: FND_GLOBAL.CONC_PROGRAM_ID,

2853: USERENV('LANG'),
2854: FND_GLOBAL.CONC_REQUEST_ID,
2855: FND_GLOBAL.PROG_APPL_ID,
2856: SYSDATE,
2857: FND_GLOBAL.CONC_PROGRAM_ID,
2858: NULL,
2859: NULL,
2860: p_org_id
2861: FROM fnd_languages l

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

2947: OZF_SD_REQUEST_LINES_PKG.Insert_Row(
2948: p_request_line_id =>l_req_line_seq
2949: ,p_object_version_number =>1
2950: ,p_last_update_date =>SYSDATE
2951: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
2952: ,p_creation_date =>SYSDATE
2953: ,p_created_by =>NVL(FND_GLOBAL.user_id,-1)
2954: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
2955: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID

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

2949: ,p_object_version_number =>1
2950: ,p_last_update_date =>SYSDATE
2951: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
2952: ,p_creation_date =>SYSDATE
2953: ,p_created_by =>NVL(FND_GLOBAL.user_id,-1)
2954: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
2955: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID
2956: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID
2957: ,p_program_update_date =>SYSDATE

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

2950: ,p_last_update_date =>SYSDATE
2951: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
2952: ,p_creation_date =>SYSDATE
2953: ,p_created_by =>NVL(FND_GLOBAL.user_id,-1)
2954: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
2955: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID
2956: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID
2957: ,p_program_update_date =>SYSDATE
2958: ,p_program_id =>FND_GLOBAL.CONC_PROGRAM_ID

Line 2955: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID

2951: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
2952: ,p_creation_date =>SYSDATE
2953: ,p_created_by =>NVL(FND_GLOBAL.user_id,-1)
2954: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
2955: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID
2956: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID
2957: ,p_program_update_date =>SYSDATE
2958: ,p_program_id =>FND_GLOBAL.CONC_PROGRAM_ID
2959: ,p_create_from =>p_SDR_lines_tbl(p).create_from

Line 2956: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID

2952: ,p_creation_date =>SYSDATE
2953: ,p_created_by =>NVL(FND_GLOBAL.user_id,-1)
2954: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
2955: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID
2956: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID
2957: ,p_program_update_date =>SYSDATE
2958: ,p_program_id =>FND_GLOBAL.CONC_PROGRAM_ID
2959: ,p_create_from =>p_SDR_lines_tbl(p).create_from
2960: ,p_request_header_id =>p_request_header_id

Line 2958: ,p_program_id =>FND_GLOBAL.CONC_PROGRAM_ID

2954: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
2955: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID
2956: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID
2957: ,p_program_update_date =>SYSDATE
2958: ,p_program_id =>FND_GLOBAL.CONC_PROGRAM_ID
2959: ,p_create_from =>p_SDR_lines_tbl(p).create_from
2960: ,p_request_header_id =>p_request_header_id
2961: ,p_product_context =>p_SDR_lines_tbl(p).product_context
2962: ,p_inventory_item_id =>p_SDR_lines_tbl(p).inventory_item_id

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

3016: OZF_SD_REQUEST_LINES_PKG.Update_Row(
3017: p_request_line_id =>p_SDR_lines_tbl(p).request_line_id
3018: ,p_object_version_number =>p_SDR_lines_tbl(p).object_version_number + 1
3019: ,p_last_update_date =>SYSDATE
3020: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
3021: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
3022: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID
3023: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID
3024: ,p_program_update_date =>SYSDATE

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

3017: p_request_line_id =>p_SDR_lines_tbl(p).request_line_id
3018: ,p_object_version_number =>p_SDR_lines_tbl(p).object_version_number + 1
3019: ,p_last_update_date =>SYSDATE
3020: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
3021: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
3022: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID
3023: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID
3024: ,p_program_update_date =>SYSDATE
3025: ,p_program_id =>FND_GLOBAL.CONC_PROGRAM_ID

Line 3022: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID

3018: ,p_object_version_number =>p_SDR_lines_tbl(p).object_version_number + 1
3019: ,p_last_update_date =>SYSDATE
3020: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
3021: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
3022: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID
3023: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID
3024: ,p_program_update_date =>SYSDATE
3025: ,p_program_id =>FND_GLOBAL.CONC_PROGRAM_ID
3026: ,p_create_from =>p_SDR_lines_tbl(p).create_from

Line 3023: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID

3019: ,p_last_update_date =>SYSDATE
3020: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
3021: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
3022: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID
3023: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID
3024: ,p_program_update_date =>SYSDATE
3025: ,p_program_id =>FND_GLOBAL.CONC_PROGRAM_ID
3026: ,p_create_from =>p_SDR_lines_tbl(p).create_from
3027: ,p_request_header_id =>p_request_header_id

Line 3025: ,p_program_id =>FND_GLOBAL.CONC_PROGRAM_ID

3021: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
3022: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID
3023: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID
3024: ,p_program_update_date =>SYSDATE
3025: ,p_program_id =>FND_GLOBAL.CONC_PROGRAM_ID
3026: ,p_create_from =>p_SDR_lines_tbl(p).create_from
3027: ,p_request_header_id =>p_request_header_id
3028: ,p_product_context =>p_SDR_lines_tbl(p).product_context
3029: ,p_inventory_item_id =>p_SDR_lines_tbl(p).inventory_item_id

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

3190: ,p_site_use_id =>p_SDR_cust_tbl(c).site_use_id
3191: ,p_cust_usage_code =>p_SDR_cust_tbl(c).cust_usage_code
3192: ,p_security_group_id =>NULL
3193: ,p_creation_date =>SYSDATE
3194: ,p_created_by =>NVL(FND_GLOBAL.user_id,-1)
3195: ,p_last_update_date =>SYSDATE
3196: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
3197: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
3198: ,p_object_version_number =>1

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

3192: ,p_security_group_id =>NULL
3193: ,p_creation_date =>SYSDATE
3194: ,p_created_by =>NVL(FND_GLOBAL.user_id,-1)
3195: ,p_last_update_date =>SYSDATE
3196: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
3197: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
3198: ,p_object_version_number =>1
3199: ,p_attribute_category =>p_SDR_cust_tbl(c).attribute_category
3200: ,p_attribute1 =>p_SDR_cust_tbl(c).attribute1

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

3193: ,p_creation_date =>SYSDATE
3194: ,p_created_by =>NVL(FND_GLOBAL.user_id,-1)
3195: ,p_last_update_date =>SYSDATE
3196: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
3197: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
3198: ,p_object_version_number =>1
3199: ,p_attribute_category =>p_SDR_cust_tbl(c).attribute_category
3200: ,p_attribute1 =>p_SDR_cust_tbl(c).attribute1
3201: ,p_attribute2 =>p_SDR_cust_tbl(c).attribute2

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

3230: ,p_site_use_id =>p_SDR_cust_tbl(c).site_use_id
3231: ,p_cust_usage_code =>p_SDR_cust_tbl(c).cust_usage_code
3232: ,p_security_group_id =>NULL
3233: ,p_last_update_date =>SYSDATE
3234: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
3235: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
3236: ,p_object_version_number =>p_SDR_cust_tbl(c).object_version_number + 1
3237: ,p_attribute_category =>p_SDR_cust_tbl(c).attribute_category
3238: ,p_attribute1 =>p_SDR_cust_tbl(c).attribute1

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

3231: ,p_cust_usage_code =>p_SDR_cust_tbl(c).cust_usage_code
3232: ,p_security_group_id =>NULL
3233: ,p_last_update_date =>SYSDATE
3234: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
3235: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
3236: ,p_object_version_number =>p_SDR_cust_tbl(c).object_version_number + 1
3237: ,p_attribute_category =>p_SDR_cust_tbl(c).attribute_category
3238: ,p_attribute1 =>p_SDR_cust_tbl(c).attribute1
3239: ,p_attribute2 =>p_SDR_cust_tbl(c).attribute2

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

3319: OZF_SD_REQUEST_HEADER_PKG.Update_Row(
3320: p_request_header_id =>p_SDR_hdr_rec.request_header_id
3321: ,p_object_version_number =>p_SDR_hdr_rec.object_version_number + 1
3322: ,p_last_update_date =>SYSDATE
3323: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
3324: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
3325: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID
3326: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID
3327: ,p_program_update_date =>SYSDATE

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

3320: p_request_header_id =>p_SDR_hdr_rec.request_header_id
3321: ,p_object_version_number =>p_SDR_hdr_rec.object_version_number + 1
3322: ,p_last_update_date =>SYSDATE
3323: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
3324: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
3325: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID
3326: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID
3327: ,p_program_update_date =>SYSDATE
3328: ,p_program_id =>FND_GLOBAL.CONC_PROGRAM_ID

Line 3325: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID

3321: ,p_object_version_number =>p_SDR_hdr_rec.object_version_number + 1
3322: ,p_last_update_date =>SYSDATE
3323: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
3324: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
3325: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID
3326: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID
3327: ,p_program_update_date =>SYSDATE
3328: ,p_program_id =>FND_GLOBAL.CONC_PROGRAM_ID
3329: ,p_created_from =>NULL

Line 3326: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID

3322: ,p_last_update_date =>SYSDATE
3323: ,p_last_updated_by =>NVL(FND_GLOBAL.user_id,-1)
3324: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
3325: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID
3326: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID
3327: ,p_program_update_date =>SYSDATE
3328: ,p_program_id =>FND_GLOBAL.CONC_PROGRAM_ID
3329: ,p_created_from =>NULL
3330: ,p_request_number =>p_SDR_hdr_rec.request_number

Line 3328: ,p_program_id =>FND_GLOBAL.CONC_PROGRAM_ID

3324: ,p_last_update_login =>NVL(FND_GLOBAL.conc_login_id,-1)
3325: ,p_request_id =>FND_GLOBAL.CONC_REQUEST_ID
3326: ,p_program_application_id =>FND_GLOBAL.PROG_APPL_ID
3327: ,p_program_update_date =>SYSDATE
3328: ,p_program_id =>FND_GLOBAL.CONC_PROGRAM_ID
3329: ,p_created_from =>NULL
3330: ,p_request_number =>p_SDR_hdr_rec.request_number
3331: ,p_request_class =>'SD_REQUEST'
3332: ,p_offer_type =>l_offer_type

Line 5199: l_user_id := FND_GLOBAL.user_id;

5195: x_return_status := FND_API.G_RET_STS_SUCCESS;
5196: --==============================================================================
5197: --//Bug 7190421 - User Check and population
5198:
5199: l_user_id := FND_GLOBAL.user_id;
5200:
5201: IF G_DEBUG THEN
5202: OZF_UTILITY_PVT.debug_message('l_user_id: ' ||l_user_id);
5203: END IF;