[Home] [Help]
807: WHERE request_header_id = cv_request_id;
808:
809: CURSOR csr_offer_type(cv_offer_id IN NUMBER) IS
810: SELECT offer_type
811: FROM ozf_offers
812: WHERE qp_list_header_id = cv_offer_id;
813:
814: --Ship - Debit Enhancements / Added by Pranay
815: CURSOR csr_sd_offer_id(cv_request_id IN NUMBER) IS
1298: FND_DSQL.add_text('DECODE(NVL('''||l_currency_rec.claim_currency_code||''',fu.PLAN_CURRENCY_CODE), fu.PLAN_CURRENCY_CODE, fu.PLAN_CURRENCY_CODE, '''||l_currency_rec.functional_currency_code||''') currency_code, ');
1299: END IF;
1300:
1301: FND_DSQL.add_text( 'fu.bill_to_site_use_id, fu.plan_curr_amount, fu.plan_curr_amount_remaining, fu.plan_currency_code ' || --ninarasi fix for bug 13550004
1302: 'FROM ozf_funds_utilized_all_b fu, ozf_offers o ');
1303: --Fix for Bug 11793070
1304: IF(l_funds_util_flt.period_name IS NOT NULL)THEN
1305: FND_DSQL.add_text( ', OZF_TIME_ENT_QTR teq ');
1306: END IF;
1460:
1461: CURSOR csr_request_offer(cv_request_id IN NUMBER) IS
1462: SELECT o.qp_list_header_id
1463: , o.offer_type
1464: FROM ozf_offers o
1465: , ozf_request_headers_all_b r
1466: WHERE o.qp_list_header_id = r.offer_id
1467: AND r.request_header_id = cv_request_id;
1468: -- Added For Multi Currency - kpatro (As For Public API this is the starting point)
6940: SELECT act.SCAN_VALUE
6941: , act.UOM_CODE
6942: , act.Quantity
6943: , off.TRANSACTION_CURRENCY_CODE
6944: FROM ozf_offers off
6945: , ams_act_products act
6946: WHERE offer_code = cv_agreement_number
6947: AND ARC_ACT_PRODUCT_USED_BY = 'OFFR'
6948: AND ACT_PRODUCT_USED_BY_ID = off.qp_list_header_id
7429: SELECT act.SCAN_VALUE
7430: , act.UOM_CODE
7431: , act.Quantity
7432: , off.TRANSACTION_CURRENCY_CODE
7433: FROM ozf_offers off
7434: , ams_act_products act
7435: WHERE offer_code = cv_agreement_number
7436: AND ARC_ACT_PRODUCT_USED_BY = 'OFFR'
7437: AND ACT_PRODUCT_USED_BY_ID = off.qp_list_header_id
8687: , line.batch_curr_claim_amount
8688: , offr.transaction_currency_code
8689: FROM ozf_funds_utilized_all_b util
8690: , ozf_sd_batch_lines_all line
8691: , ozf_offers offr
8692: WHERE util.utilization_id = line.utilization_id
8693: AND util.plan_id = offr.qp_list_header_id
8694: AND line.batch_id = cv_batch_id
8695: AND line.item_id = cv_product_id
9189:
9190: CURSOR csr_offer_status(cv_offer_id IN NUMBER) IS
9191: SELECT status_code
9192: , transaction_currency_code
9193: FROM ozf_offers
9194: WHERE qp_list_header_id = cv_offer_id;
9195:
9196: BEGIN
9197:
10416: where claim_line_id = cv_claim_line_id;
10417:
10418: CURSOR csr_offer_currency(cv_plan_id IN NUMBER) IS
10419: SELECT transaction_currency_code
10420: FROM ozf_offers
10421: WHERE qp_list_header_id = cv_plan_id;
10422:
10423: CURSOR csr_over_util(cv_claim_line_id IN NUMBER, cv_act_product_id IN NUMBER) IS
10424: SELECT claim_line_util_id, acctd_amount, scan_unit
11979: -- , acctd_amount
11980: , amount --7169388
11981: , fund.approved_in_currency --7231613 --//SD MC
11982: FROM ozf_claim_lines_all lines
11983: , ozf_offers offr
11984: , ozf_act_budgets fund
11985: , ozf_sd_request_headers_all_b req
11986: WHERE claim_id = cv_claim_id
11987: AND lines.activity_id = req.request_header_id
11999: , lines.item_id
12000: , lines.amount
12001: , offr.transaction_currency_code
12002: FROM ozf_claim_lines_all lines
12003: , ozf_offers offr
12004: , ozf_sd_request_headers_all_b req
12005: WHERE claim_id = cv_claim_id
12006: AND lines.activity_id = req.request_header_id
12007: AND req.offer_id = offr.qp_list_header_id;
12049:
12050: CURSOR cur_offer_currency(cv_request_id IN NUMBER) IS
12051: SELECT offr.transaction_currency_code
12052: FROM ozf_sd_request_headers_all_b req
12053: , ozf_offers offr
12054: WHERE offr.qp_list_header_id = req.offer_id
12055: AND req.request_header_id = cv_request_id;
12056:
12057: --Vendor details added for bug 6921727