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

Line 1113: l_SDR_hdr_pub_rec OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type;

1109: V_PRICING_ATTR_val_tbl QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type;
1110: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1111: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1112:
1113: l_SDR_hdr_pub_rec OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type;
1114: l_SDR_lines_tbl OZF_SD_REQUEST_PUB.SDR_lines_tbl_type;
1115: l_SDR_cust_tbl OZF_SD_REQUEST_PUB.SDR_cust_tbl_type;
1116: l_custom_setup_id NUMBER;
1117: l_list_line_id NUMBER;

Line 1114: l_SDR_lines_tbl OZF_SD_REQUEST_PUB.SDR_lines_tbl_type;

1110: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1111: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1112:
1113: l_SDR_hdr_pub_rec OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type;
1114: l_SDR_lines_tbl OZF_SD_REQUEST_PUB.SDR_lines_tbl_type;
1115: l_SDR_cust_tbl OZF_SD_REQUEST_PUB.SDR_cust_tbl_type;
1116: l_custom_setup_id NUMBER;
1117: l_list_line_id NUMBER;
1118: l_list_line_no NUMBER;

Line 1115: l_SDR_cust_tbl OZF_SD_REQUEST_PUB.SDR_cust_tbl_type;

1111: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1112:
1113: l_SDR_hdr_pub_rec OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type;
1114: l_SDR_lines_tbl OZF_SD_REQUEST_PUB.SDR_lines_tbl_type;
1115: l_SDR_cust_tbl OZF_SD_REQUEST_PUB.SDR_cust_tbl_type;
1116: l_custom_setup_id NUMBER;
1117: l_list_line_id NUMBER;
1118: l_list_line_no NUMBER;
1119: l_start_date_active DATE;

Line 1344: OZF_SD_REQUEST_PUB.update_sd_Request(

1340: END IF;
1341: END IF;
1342: END LOOP;
1343:
1344: OZF_SD_REQUEST_PUB.update_sd_Request(
1345: p_api_version_number => 1.0,
1346: p_init_msg_list => FND_API.G_TRUE,
1347: p_commit => FND_API.G_FALSE,
1348: p_validation_level => FND_API.g_valid_level_full,

Line 3574: p_SDR_hdr_pub_rec OUT NOCOPY OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type )

3570: END IF;
3571: END processDisDiscounts;
3572:
3573: PROCEDURE populate_sdr_hdr_rec(p_list_header_id IN NUMBER,
3574: p_SDR_hdr_pub_rec OUT NOCOPY OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type )
3575: IS
3576: CURSOR c_get_sdr_hdr IS
3577: SELECT request_header_id
3578: ,object_version_number

Line 3608: px_SDR_lines_tbl IN OUT NOCOPY OZF_SD_REQUEST_PUB.SDR_lines_tbl_type,

3604:
3605: END populate_sdr_hdr_rec;
3606:
3607: PROCEDURE populate_new_sdr_line_rec(px_modifier_line_tbl IN OUT NOCOPY ozf_offer_pvt.modifier_line_tbl_type,
3608: px_SDR_lines_tbl IN OUT NOCOPY OZF_SD_REQUEST_PUB.SDR_lines_tbl_type,
3609: p_SDR_hdr_pub_rec IN OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type)
3610: IS
3611: CURSOR c_reqest_lines_seq IS
3612: SELECT ozf_sd_request_lines_all_s.nextval

Line 3609: p_SDR_hdr_pub_rec IN OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type)

3605: END populate_sdr_hdr_rec;
3606:
3607: PROCEDURE populate_new_sdr_line_rec(px_modifier_line_tbl IN OUT NOCOPY ozf_offer_pvt.modifier_line_tbl_type,
3608: px_SDR_lines_tbl IN OUT NOCOPY OZF_SD_REQUEST_PUB.SDR_lines_tbl_type,
3609: p_SDR_hdr_pub_rec IN OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type)
3610: IS
3611: CURSOR c_reqest_lines_seq IS
3612: SELECT ozf_sd_request_lines_all_s.nextval
3613: FROM dual;

Line 3769: l_SDR_hdr_pub_rec OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type;

3765: l_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;
3766: l_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
3767: l_errorLocation NUMBER;
3768: l_custom_setup_id NUMBER;
3769: l_SDR_hdr_pub_rec OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type;
3770: l_SDR_lines_tbl OZF_SD_REQUEST_PUB.SDR_lines_tbl_type;
3771: l_SDR_cust_tbl OZF_SD_REQUEST_PUB.SDR_cust_tbl_type;
3772:
3773:

Line 3770: l_SDR_lines_tbl OZF_SD_REQUEST_PUB.SDR_lines_tbl_type;

3766: l_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
3767: l_errorLocation NUMBER;
3768: l_custom_setup_id NUMBER;
3769: l_SDR_hdr_pub_rec OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type;
3770: l_SDR_lines_tbl OZF_SD_REQUEST_PUB.SDR_lines_tbl_type;
3771: l_SDR_cust_tbl OZF_SD_REQUEST_PUB.SDR_cust_tbl_type;
3772:
3773:
3774: CURSOR c_offer_type (p_list_header_id IN NUMBER) IS

Line 3771: l_SDR_cust_tbl OZF_SD_REQUEST_PUB.SDR_cust_tbl_type;

3767: l_errorLocation NUMBER;
3768: l_custom_setup_id NUMBER;
3769: l_SDR_hdr_pub_rec OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type;
3770: l_SDR_lines_tbl OZF_SD_REQUEST_PUB.SDR_lines_tbl_type;
3771: l_SDR_cust_tbl OZF_SD_REQUEST_PUB.SDR_cust_tbl_type;
3772:
3773:
3774: CURSOR c_offer_type (p_list_header_id IN NUMBER) IS
3775: SELECT custom_setup_id

Line 3864: OZF_SD_REQUEST_PUB.update_sd_Request(

3860: -- create SDR header and line
3861: --===============================================================
3862:
3863: IF l_custom_setup_id = 118 THEN
3864: OZF_SD_REQUEST_PUB.update_sd_Request(
3865: p_api_version_number => 1.0,
3866: p_init_msg_list => FND_API.G_TRUE,
3867: p_commit => FND_API.G_FALSE,
3868: p_validation_level => FND_API.g_valid_level_full,