5581: INTO l_skg_rec;
5582:
5583: CLOSE l_skg_csr;
5584:
5585: oks_qpattrib_pvt.g_contract_hdrrec.chr_id := l_skg_rec.kh_id;
5586: oks_qpattrib_pvt.g_contract_hdrrec.top_line_id := NULL;
5587: oks_qpattrib_pvt.g_contract_hdrrec.cov_line_id := NULL;
5588: oks_qpattrib_pvt.g_contract_hdrrec.inventory_item_id := NULL;
5589: oks_qpattrib_pvt.g_contract_hdrrec.invt_org_id := l_skg_rec.inv_org;
5582:
5583: CLOSE l_skg_csr;
5584:
5585: oks_qpattrib_pvt.g_contract_hdrrec.chr_id := l_skg_rec.kh_id;
5586: oks_qpattrib_pvt.g_contract_hdrrec.top_line_id := NULL;
5587: oks_qpattrib_pvt.g_contract_hdrrec.cov_line_id := NULL;
5588: oks_qpattrib_pvt.g_contract_hdrrec.inventory_item_id := NULL;
5589: oks_qpattrib_pvt.g_contract_hdrrec.invt_org_id := l_skg_rec.inv_org;
5590: oks_qpattrib_pvt.g_contract_hdrrec.auth_org_id :=
5583: CLOSE l_skg_csr;
5584:
5585: oks_qpattrib_pvt.g_contract_hdrrec.chr_id := l_skg_rec.kh_id;
5586: oks_qpattrib_pvt.g_contract_hdrrec.top_line_id := NULL;
5587: oks_qpattrib_pvt.g_contract_hdrrec.cov_line_id := NULL;
5588: oks_qpattrib_pvt.g_contract_hdrrec.inventory_item_id := NULL;
5589: oks_qpattrib_pvt.g_contract_hdrrec.invt_org_id := l_skg_rec.inv_org;
5590: oks_qpattrib_pvt.g_contract_hdrrec.auth_org_id :=
5591: l_skg_rec.kh_auth_org;
5584:
5585: oks_qpattrib_pvt.g_contract_hdrrec.chr_id := l_skg_rec.kh_id;
5586: oks_qpattrib_pvt.g_contract_hdrrec.top_line_id := NULL;
5587: oks_qpattrib_pvt.g_contract_hdrrec.cov_line_id := NULL;
5588: oks_qpattrib_pvt.g_contract_hdrrec.inventory_item_id := NULL;
5589: oks_qpattrib_pvt.g_contract_hdrrec.invt_org_id := l_skg_rec.inv_org;
5590: oks_qpattrib_pvt.g_contract_hdrrec.auth_org_id :=
5591: l_skg_rec.kh_auth_org;
5592: oks_qpattrib_pvt.g_contract_hdrrec.pricing_date := l_def_pricing_date;
5585: oks_qpattrib_pvt.g_contract_hdrrec.chr_id := l_skg_rec.kh_id;
5586: oks_qpattrib_pvt.g_contract_hdrrec.top_line_id := NULL;
5587: oks_qpattrib_pvt.g_contract_hdrrec.cov_line_id := NULL;
5588: oks_qpattrib_pvt.g_contract_hdrrec.inventory_item_id := NULL;
5589: oks_qpattrib_pvt.g_contract_hdrrec.invt_org_id := l_skg_rec.inv_org;
5590: oks_qpattrib_pvt.g_contract_hdrrec.auth_org_id :=
5591: l_skg_rec.kh_auth_org;
5592: oks_qpattrib_pvt.g_contract_hdrrec.pricing_date := l_def_pricing_date;
5593: oks_qpattrib_pvt.g_contract_hdrrec.party_id :=
5586: oks_qpattrib_pvt.g_contract_hdrrec.top_line_id := NULL;
5587: oks_qpattrib_pvt.g_contract_hdrrec.cov_line_id := NULL;
5588: oks_qpattrib_pvt.g_contract_hdrrec.inventory_item_id := NULL;
5589: oks_qpattrib_pvt.g_contract_hdrrec.invt_org_id := l_skg_rec.inv_org;
5590: oks_qpattrib_pvt.g_contract_hdrrec.auth_org_id :=
5591: l_skg_rec.kh_auth_org;
5592: oks_qpattrib_pvt.g_contract_hdrrec.pricing_date := l_def_pricing_date;
5593: oks_qpattrib_pvt.g_contract_hdrrec.party_id :=
5594: get_party_id (l_skg_rec.kh_id);
5588: oks_qpattrib_pvt.g_contract_hdrrec.inventory_item_id := NULL;
5589: oks_qpattrib_pvt.g_contract_hdrrec.invt_org_id := l_skg_rec.inv_org;
5590: oks_qpattrib_pvt.g_contract_hdrrec.auth_org_id :=
5591: l_skg_rec.kh_auth_org;
5592: oks_qpattrib_pvt.g_contract_hdrrec.pricing_date := l_def_pricing_date;
5593: oks_qpattrib_pvt.g_contract_hdrrec.party_id :=
5594: get_party_id (l_skg_rec.kh_id);
5595: oks_qpattrib_pvt.g_contract_hdrrec.customer_id :=
5596: get_customer_from_siteuse (l_skg_rec.kh_bill_to);
5589: oks_qpattrib_pvt.g_contract_hdrrec.invt_org_id := l_skg_rec.inv_org;
5590: oks_qpattrib_pvt.g_contract_hdrrec.auth_org_id :=
5591: l_skg_rec.kh_auth_org;
5592: oks_qpattrib_pvt.g_contract_hdrrec.pricing_date := l_def_pricing_date;
5593: oks_qpattrib_pvt.g_contract_hdrrec.party_id :=
5594: get_party_id (l_skg_rec.kh_id);
5595: oks_qpattrib_pvt.g_contract_hdrrec.customer_id :=
5596: get_customer_from_siteuse (l_skg_rec.kh_bill_to);
5597: oks_qpattrib_pvt.g_contract_hdrrec.agreement_id :=
5591: l_skg_rec.kh_auth_org;
5592: oks_qpattrib_pvt.g_contract_hdrrec.pricing_date := l_def_pricing_date;
5593: oks_qpattrib_pvt.g_contract_hdrrec.party_id :=
5594: get_party_id (l_skg_rec.kh_id);
5595: oks_qpattrib_pvt.g_contract_hdrrec.customer_id :=
5596: get_customer_from_siteuse (l_skg_rec.kh_bill_to);
5597: oks_qpattrib_pvt.g_contract_hdrrec.agreement_id :=
5598: get_agreement_id (l_skg_rec.kh_id);
5599: oks_qpattrib_pvt.g_contract_hdrrec.bill_to := l_skg_rec.kh_bill_to;
5593: oks_qpattrib_pvt.g_contract_hdrrec.party_id :=
5594: get_party_id (l_skg_rec.kh_id);
5595: oks_qpattrib_pvt.g_contract_hdrrec.customer_id :=
5596: get_customer_from_siteuse (l_skg_rec.kh_bill_to);
5597: oks_qpattrib_pvt.g_contract_hdrrec.agreement_id :=
5598: get_agreement_id (l_skg_rec.kh_id);
5599: oks_qpattrib_pvt.g_contract_hdrrec.bill_to := l_skg_rec.kh_bill_to;
5600: oks_qpattrib_pvt.g_contract_hdrrec.ship_to := l_skg_rec.kh_ship_to;
5601: oks_qpattrib_pvt.g_contract_hdrrec.payment_term_id :=
5595: oks_qpattrib_pvt.g_contract_hdrrec.customer_id :=
5596: get_customer_from_siteuse (l_skg_rec.kh_bill_to);
5597: oks_qpattrib_pvt.g_contract_hdrrec.agreement_id :=
5598: get_agreement_id (l_skg_rec.kh_id);
5599: oks_qpattrib_pvt.g_contract_hdrrec.bill_to := l_skg_rec.kh_bill_to;
5600: oks_qpattrib_pvt.g_contract_hdrrec.ship_to := l_skg_rec.kh_ship_to;
5601: oks_qpattrib_pvt.g_contract_hdrrec.payment_term_id :=
5602: l_skg_rec.kh_payment_term_id;
5603: oks_qpattrib_pvt.g_contract_linrec.chr_id := NULL;
5596: get_customer_from_siteuse (l_skg_rec.kh_bill_to);
5597: oks_qpattrib_pvt.g_contract_hdrrec.agreement_id :=
5598: get_agreement_id (l_skg_rec.kh_id);
5599: oks_qpattrib_pvt.g_contract_hdrrec.bill_to := l_skg_rec.kh_bill_to;
5600: oks_qpattrib_pvt.g_contract_hdrrec.ship_to := l_skg_rec.kh_ship_to;
5601: oks_qpattrib_pvt.g_contract_hdrrec.payment_term_id :=
5602: l_skg_rec.kh_payment_term_id;
5603: oks_qpattrib_pvt.g_contract_linrec.chr_id := NULL;
5604: oks_qpattrib_pvt.g_contract_linrec.top_line_id := NULL;
5597: oks_qpattrib_pvt.g_contract_hdrrec.agreement_id :=
5598: get_agreement_id (l_skg_rec.kh_id);
5599: oks_qpattrib_pvt.g_contract_hdrrec.bill_to := l_skg_rec.kh_bill_to;
5600: oks_qpattrib_pvt.g_contract_hdrrec.ship_to := l_skg_rec.kh_ship_to;
5601: oks_qpattrib_pvt.g_contract_hdrrec.payment_term_id :=
5602: l_skg_rec.kh_payment_term_id;
5603: oks_qpattrib_pvt.g_contract_linrec.chr_id := NULL;
5604: oks_qpattrib_pvt.g_contract_linrec.top_line_id := NULL;
5605: oks_qpattrib_pvt.g_contract_linrec.cov_line_id := NULL;
5599: oks_qpattrib_pvt.g_contract_hdrrec.bill_to := l_skg_rec.kh_bill_to;
5600: oks_qpattrib_pvt.g_contract_hdrrec.ship_to := l_skg_rec.kh_ship_to;
5601: oks_qpattrib_pvt.g_contract_hdrrec.payment_term_id :=
5602: l_skg_rec.kh_payment_term_id;
5603: oks_qpattrib_pvt.g_contract_linrec.chr_id := NULL;
5604: oks_qpattrib_pvt.g_contract_linrec.top_line_id := NULL;
5605: oks_qpattrib_pvt.g_contract_linrec.cov_line_id := NULL;
5606: oks_qpattrib_pvt.g_contract_linrec.inventory_item_id := NULL;
5607: oks_qpattrib_pvt.g_contract_linrec.invt_org_id := NULL;
5600: oks_qpattrib_pvt.g_contract_hdrrec.ship_to := l_skg_rec.kh_ship_to;
5601: oks_qpattrib_pvt.g_contract_hdrrec.payment_term_id :=
5602: l_skg_rec.kh_payment_term_id;
5603: oks_qpattrib_pvt.g_contract_linrec.chr_id := NULL;
5604: oks_qpattrib_pvt.g_contract_linrec.top_line_id := NULL;
5605: oks_qpattrib_pvt.g_contract_linrec.cov_line_id := NULL;
5606: oks_qpattrib_pvt.g_contract_linrec.inventory_item_id := NULL;
5607: oks_qpattrib_pvt.g_contract_linrec.invt_org_id := NULL;
5608: oks_qpattrib_pvt.g_contract_linrec.auth_org_id := NULL;
5601: oks_qpattrib_pvt.g_contract_hdrrec.payment_term_id :=
5602: l_skg_rec.kh_payment_term_id;
5603: oks_qpattrib_pvt.g_contract_linrec.chr_id := NULL;
5604: oks_qpattrib_pvt.g_contract_linrec.top_line_id := NULL;
5605: oks_qpattrib_pvt.g_contract_linrec.cov_line_id := NULL;
5606: oks_qpattrib_pvt.g_contract_linrec.inventory_item_id := NULL;
5607: oks_qpattrib_pvt.g_contract_linrec.invt_org_id := NULL;
5608: oks_qpattrib_pvt.g_contract_linrec.auth_org_id := NULL;
5609: oks_qpattrib_pvt.g_contract_linrec.pricing_date := NULL;
5602: l_skg_rec.kh_payment_term_id;
5603: oks_qpattrib_pvt.g_contract_linrec.chr_id := NULL;
5604: oks_qpattrib_pvt.g_contract_linrec.top_line_id := NULL;
5605: oks_qpattrib_pvt.g_contract_linrec.cov_line_id := NULL;
5606: oks_qpattrib_pvt.g_contract_linrec.inventory_item_id := NULL;
5607: oks_qpattrib_pvt.g_contract_linrec.invt_org_id := NULL;
5608: oks_qpattrib_pvt.g_contract_linrec.auth_org_id := NULL;
5609: oks_qpattrib_pvt.g_contract_linrec.pricing_date := NULL;
5610: oks_qpattrib_pvt.g_contract_linrec.party_id := NULL;
5603: oks_qpattrib_pvt.g_contract_linrec.chr_id := NULL;
5604: oks_qpattrib_pvt.g_contract_linrec.top_line_id := NULL;
5605: oks_qpattrib_pvt.g_contract_linrec.cov_line_id := NULL;
5606: oks_qpattrib_pvt.g_contract_linrec.inventory_item_id := NULL;
5607: oks_qpattrib_pvt.g_contract_linrec.invt_org_id := NULL;
5608: oks_qpattrib_pvt.g_contract_linrec.auth_org_id := NULL;
5609: oks_qpattrib_pvt.g_contract_linrec.pricing_date := NULL;
5610: oks_qpattrib_pvt.g_contract_linrec.party_id := NULL;
5611: oks_qpattrib_pvt.g_contract_linrec.customer_id := NULL;
5604: oks_qpattrib_pvt.g_contract_linrec.top_line_id := NULL;
5605: oks_qpattrib_pvt.g_contract_linrec.cov_line_id := NULL;
5606: oks_qpattrib_pvt.g_contract_linrec.inventory_item_id := NULL;
5607: oks_qpattrib_pvt.g_contract_linrec.invt_org_id := NULL;
5608: oks_qpattrib_pvt.g_contract_linrec.auth_org_id := NULL;
5609: oks_qpattrib_pvt.g_contract_linrec.pricing_date := NULL;
5610: oks_qpattrib_pvt.g_contract_linrec.party_id := NULL;
5611: oks_qpattrib_pvt.g_contract_linrec.customer_id := NULL;
5612: oks_qpattrib_pvt.g_contract_linrec.bill_to := NULL;
5605: oks_qpattrib_pvt.g_contract_linrec.cov_line_id := NULL;
5606: oks_qpattrib_pvt.g_contract_linrec.inventory_item_id := NULL;
5607: oks_qpattrib_pvt.g_contract_linrec.invt_org_id := NULL;
5608: oks_qpattrib_pvt.g_contract_linrec.auth_org_id := NULL;
5609: oks_qpattrib_pvt.g_contract_linrec.pricing_date := NULL;
5610: oks_qpattrib_pvt.g_contract_linrec.party_id := NULL;
5611: oks_qpattrib_pvt.g_contract_linrec.customer_id := NULL;
5612: oks_qpattrib_pvt.g_contract_linrec.bill_to := NULL;
5613: oks_qpattrib_pvt.g_contract_linrec.ship_to := NULL;
5606: oks_qpattrib_pvt.g_contract_linrec.inventory_item_id := NULL;
5607: oks_qpattrib_pvt.g_contract_linrec.invt_org_id := NULL;
5608: oks_qpattrib_pvt.g_contract_linrec.auth_org_id := NULL;
5609: oks_qpattrib_pvt.g_contract_linrec.pricing_date := NULL;
5610: oks_qpattrib_pvt.g_contract_linrec.party_id := NULL;
5611: oks_qpattrib_pvt.g_contract_linrec.customer_id := NULL;
5612: oks_qpattrib_pvt.g_contract_linrec.bill_to := NULL;
5613: oks_qpattrib_pvt.g_contract_linrec.ship_to := NULL;
5614: oks_qpattrib_pvt.g_contract_linrec.payment_term_id := NULL;
5607: oks_qpattrib_pvt.g_contract_linrec.invt_org_id := NULL;
5608: oks_qpattrib_pvt.g_contract_linrec.auth_org_id := NULL;
5609: oks_qpattrib_pvt.g_contract_linrec.pricing_date := NULL;
5610: oks_qpattrib_pvt.g_contract_linrec.party_id := NULL;
5611: oks_qpattrib_pvt.g_contract_linrec.customer_id := NULL;
5612: oks_qpattrib_pvt.g_contract_linrec.bill_to := NULL;
5613: oks_qpattrib_pvt.g_contract_linrec.ship_to := NULL;
5614: oks_qpattrib_pvt.g_contract_linrec.payment_term_id := NULL;
5615: ELSE
5608: oks_qpattrib_pvt.g_contract_linrec.auth_org_id := NULL;
5609: oks_qpattrib_pvt.g_contract_linrec.pricing_date := NULL;
5610: oks_qpattrib_pvt.g_contract_linrec.party_id := NULL;
5611: oks_qpattrib_pvt.g_contract_linrec.customer_id := NULL;
5612: oks_qpattrib_pvt.g_contract_linrec.bill_to := NULL;
5613: oks_qpattrib_pvt.g_contract_linrec.ship_to := NULL;
5614: oks_qpattrib_pvt.g_contract_linrec.payment_term_id := NULL;
5615: ELSE
5616: oks_qpattrib_pvt.g_contract_hdrrec.chr_id := l_hdrtop_rec.kh_id;
5609: oks_qpattrib_pvt.g_contract_linrec.pricing_date := NULL;
5610: oks_qpattrib_pvt.g_contract_linrec.party_id := NULL;
5611: oks_qpattrib_pvt.g_contract_linrec.customer_id := NULL;
5612: oks_qpattrib_pvt.g_contract_linrec.bill_to := NULL;
5613: oks_qpattrib_pvt.g_contract_linrec.ship_to := NULL;
5614: oks_qpattrib_pvt.g_contract_linrec.payment_term_id := NULL;
5615: ELSE
5616: oks_qpattrib_pvt.g_contract_hdrrec.chr_id := l_hdrtop_rec.kh_id;
5617: oks_qpattrib_pvt.g_contract_hdrrec.top_line_id := l_hdrtop_rec.tl_id;
5610: oks_qpattrib_pvt.g_contract_linrec.party_id := NULL;
5611: oks_qpattrib_pvt.g_contract_linrec.customer_id := NULL;
5612: oks_qpattrib_pvt.g_contract_linrec.bill_to := NULL;
5613: oks_qpattrib_pvt.g_contract_linrec.ship_to := NULL;
5614: oks_qpattrib_pvt.g_contract_linrec.payment_term_id := NULL;
5615: ELSE
5616: oks_qpattrib_pvt.g_contract_hdrrec.chr_id := l_hdrtop_rec.kh_id;
5617: oks_qpattrib_pvt.g_contract_hdrrec.top_line_id := l_hdrtop_rec.tl_id;
5618: oks_qpattrib_pvt.g_contract_hdrrec.cov_line_id :=
5612: oks_qpattrib_pvt.g_contract_linrec.bill_to := NULL;
5613: oks_qpattrib_pvt.g_contract_linrec.ship_to := NULL;
5614: oks_qpattrib_pvt.g_contract_linrec.payment_term_id := NULL;
5615: ELSE
5616: oks_qpattrib_pvt.g_contract_hdrrec.chr_id := l_hdrtop_rec.kh_id;
5617: oks_qpattrib_pvt.g_contract_hdrrec.top_line_id := l_hdrtop_rec.tl_id;
5618: oks_qpattrib_pvt.g_contract_hdrrec.cov_line_id :=
5619: l_subline_rec.sl_id;
5620: oks_qpattrib_pvt.g_contract_hdrrec.inventory_item_id :=
5613: oks_qpattrib_pvt.g_contract_linrec.ship_to := NULL;
5614: oks_qpattrib_pvt.g_contract_linrec.payment_term_id := NULL;
5615: ELSE
5616: oks_qpattrib_pvt.g_contract_hdrrec.chr_id := l_hdrtop_rec.kh_id;
5617: oks_qpattrib_pvt.g_contract_hdrrec.top_line_id := l_hdrtop_rec.tl_id;
5618: oks_qpattrib_pvt.g_contract_hdrrec.cov_line_id :=
5619: l_subline_rec.sl_id;
5620: oks_qpattrib_pvt.g_contract_hdrrec.inventory_item_id :=
5621: l_hdrtop_rec.tl_object_id;
5614: oks_qpattrib_pvt.g_contract_linrec.payment_term_id := NULL;
5615: ELSE
5616: oks_qpattrib_pvt.g_contract_hdrrec.chr_id := l_hdrtop_rec.kh_id;
5617: oks_qpattrib_pvt.g_contract_hdrrec.top_line_id := l_hdrtop_rec.tl_id;
5618: oks_qpattrib_pvt.g_contract_hdrrec.cov_line_id :=
5619: l_subline_rec.sl_id;
5620: oks_qpattrib_pvt.g_contract_hdrrec.inventory_item_id :=
5621: l_hdrtop_rec.tl_object_id;
5622: oks_qpattrib_pvt.g_contract_hdrrec.invt_org_id :=
5616: oks_qpattrib_pvt.g_contract_hdrrec.chr_id := l_hdrtop_rec.kh_id;
5617: oks_qpattrib_pvt.g_contract_hdrrec.top_line_id := l_hdrtop_rec.tl_id;
5618: oks_qpattrib_pvt.g_contract_hdrrec.cov_line_id :=
5619: l_subline_rec.sl_id;
5620: oks_qpattrib_pvt.g_contract_hdrrec.inventory_item_id :=
5621: l_hdrtop_rec.tl_object_id;
5622: oks_qpattrib_pvt.g_contract_hdrrec.invt_org_id :=
5623: l_hdrtop_rec.inv_org;
5624: oks_qpattrib_pvt.g_contract_hdrrec.auth_org_id :=
5618: oks_qpattrib_pvt.g_contract_hdrrec.cov_line_id :=
5619: l_subline_rec.sl_id;
5620: oks_qpattrib_pvt.g_contract_hdrrec.inventory_item_id :=
5621: l_hdrtop_rec.tl_object_id;
5622: oks_qpattrib_pvt.g_contract_hdrrec.invt_org_id :=
5623: l_hdrtop_rec.inv_org;
5624: oks_qpattrib_pvt.g_contract_hdrrec.auth_org_id :=
5625: l_hdrtop_rec.kh_auth_org;
5626: oks_qpattrib_pvt.g_contract_hdrrec.pricing_date :=
5620: oks_qpattrib_pvt.g_contract_hdrrec.inventory_item_id :=
5621: l_hdrtop_rec.tl_object_id;
5622: oks_qpattrib_pvt.g_contract_hdrrec.invt_org_id :=
5623: l_hdrtop_rec.inv_org;
5624: oks_qpattrib_pvt.g_contract_hdrrec.auth_org_id :=
5625: l_hdrtop_rec.kh_auth_org;
5626: oks_qpattrib_pvt.g_contract_hdrrec.pricing_date :=
5627: l_def_pricing_date;
5628: oks_qpattrib_pvt.g_contract_hdrrec.party_id :=
5622: oks_qpattrib_pvt.g_contract_hdrrec.invt_org_id :=
5623: l_hdrtop_rec.inv_org;
5624: oks_qpattrib_pvt.g_contract_hdrrec.auth_org_id :=
5625: l_hdrtop_rec.kh_auth_org;
5626: oks_qpattrib_pvt.g_contract_hdrrec.pricing_date :=
5627: l_def_pricing_date;
5628: oks_qpattrib_pvt.g_contract_hdrrec.party_id :=
5629: get_party_id (l_hdrtop_rec.kh_id);
5630: oks_qpattrib_pvt.g_contract_hdrrec.customer_id :=
5624: oks_qpattrib_pvt.g_contract_hdrrec.auth_org_id :=
5625: l_hdrtop_rec.kh_auth_org;
5626: oks_qpattrib_pvt.g_contract_hdrrec.pricing_date :=
5627: l_def_pricing_date;
5628: oks_qpattrib_pvt.g_contract_hdrrec.party_id :=
5629: get_party_id (l_hdrtop_rec.kh_id);
5630: oks_qpattrib_pvt.g_contract_hdrrec.customer_id :=
5631: get_customer_from_siteuse (l_hdrtop_rec.kh_bill_to);
5632: oks_qpattrib_pvt.g_contract_hdrrec.agreement_id :=
5626: oks_qpattrib_pvt.g_contract_hdrrec.pricing_date :=
5627: l_def_pricing_date;
5628: oks_qpattrib_pvt.g_contract_hdrrec.party_id :=
5629: get_party_id (l_hdrtop_rec.kh_id);
5630: oks_qpattrib_pvt.g_contract_hdrrec.customer_id :=
5631: get_customer_from_siteuse (l_hdrtop_rec.kh_bill_to);
5632: oks_qpattrib_pvt.g_contract_hdrrec.agreement_id :=
5633: get_agreement_id (l_hdrtop_rec.kh_id);
5634: oks_qpattrib_pvt.g_contract_hdrrec.bill_to :=
5628: oks_qpattrib_pvt.g_contract_hdrrec.party_id :=
5629: get_party_id (l_hdrtop_rec.kh_id);
5630: oks_qpattrib_pvt.g_contract_hdrrec.customer_id :=
5631: get_customer_from_siteuse (l_hdrtop_rec.kh_bill_to);
5632: oks_qpattrib_pvt.g_contract_hdrrec.agreement_id :=
5633: get_agreement_id (l_hdrtop_rec.kh_id);
5634: oks_qpattrib_pvt.g_contract_hdrrec.bill_to :=
5635: l_hdrtop_rec.kh_bill_to;
5636: oks_qpattrib_pvt.g_contract_hdrrec.ship_to :=
5630: oks_qpattrib_pvt.g_contract_hdrrec.customer_id :=
5631: get_customer_from_siteuse (l_hdrtop_rec.kh_bill_to);
5632: oks_qpattrib_pvt.g_contract_hdrrec.agreement_id :=
5633: get_agreement_id (l_hdrtop_rec.kh_id);
5634: oks_qpattrib_pvt.g_contract_hdrrec.bill_to :=
5635: l_hdrtop_rec.kh_bill_to;
5636: oks_qpattrib_pvt.g_contract_hdrrec.ship_to :=
5637: l_hdrtop_rec.kh_ship_to;
5638: oks_qpattrib_pvt.g_contract_hdrrec.payment_term_id :=
5632: oks_qpattrib_pvt.g_contract_hdrrec.agreement_id :=
5633: get_agreement_id (l_hdrtop_rec.kh_id);
5634: oks_qpattrib_pvt.g_contract_hdrrec.bill_to :=
5635: l_hdrtop_rec.kh_bill_to;
5636: oks_qpattrib_pvt.g_contract_hdrrec.ship_to :=
5637: l_hdrtop_rec.kh_ship_to;
5638: oks_qpattrib_pvt.g_contract_hdrrec.payment_term_id :=
5639: l_hdrtop_rec.kh_payment_term_id;
5640: oks_qpattrib_pvt.g_contract_linrec.chr_id := l_hdrtop_rec.kh_id;
5634: oks_qpattrib_pvt.g_contract_hdrrec.bill_to :=
5635: l_hdrtop_rec.kh_bill_to;
5636: oks_qpattrib_pvt.g_contract_hdrrec.ship_to :=
5637: l_hdrtop_rec.kh_ship_to;
5638: oks_qpattrib_pvt.g_contract_hdrrec.payment_term_id :=
5639: l_hdrtop_rec.kh_payment_term_id;
5640: oks_qpattrib_pvt.g_contract_linrec.chr_id := l_hdrtop_rec.kh_id;
5641: oks_qpattrib_pvt.g_contract_linrec.top_line_id := l_hdrtop_rec.tl_id;
5642: oks_qpattrib_pvt.g_contract_linrec.cov_line_id :=
5636: oks_qpattrib_pvt.g_contract_hdrrec.ship_to :=
5637: l_hdrtop_rec.kh_ship_to;
5638: oks_qpattrib_pvt.g_contract_hdrrec.payment_term_id :=
5639: l_hdrtop_rec.kh_payment_term_id;
5640: oks_qpattrib_pvt.g_contract_linrec.chr_id := l_hdrtop_rec.kh_id;
5641: oks_qpattrib_pvt.g_contract_linrec.top_line_id := l_hdrtop_rec.tl_id;
5642: oks_qpattrib_pvt.g_contract_linrec.cov_line_id :=
5643: l_subline_rec.sl_id;
5644: oks_qpattrib_pvt.g_contract_linrec.inventory_item_id :=
5637: l_hdrtop_rec.kh_ship_to;
5638: oks_qpattrib_pvt.g_contract_hdrrec.payment_term_id :=
5639: l_hdrtop_rec.kh_payment_term_id;
5640: oks_qpattrib_pvt.g_contract_linrec.chr_id := l_hdrtop_rec.kh_id;
5641: oks_qpattrib_pvt.g_contract_linrec.top_line_id := l_hdrtop_rec.tl_id;
5642: oks_qpattrib_pvt.g_contract_linrec.cov_line_id :=
5643: l_subline_rec.sl_id;
5644: oks_qpattrib_pvt.g_contract_linrec.inventory_item_id :=
5645: l_hdrtop_rec.tl_object_id;
5638: oks_qpattrib_pvt.g_contract_hdrrec.payment_term_id :=
5639: l_hdrtop_rec.kh_payment_term_id;
5640: oks_qpattrib_pvt.g_contract_linrec.chr_id := l_hdrtop_rec.kh_id;
5641: oks_qpattrib_pvt.g_contract_linrec.top_line_id := l_hdrtop_rec.tl_id;
5642: oks_qpattrib_pvt.g_contract_linrec.cov_line_id :=
5643: l_subline_rec.sl_id;
5644: oks_qpattrib_pvt.g_contract_linrec.inventory_item_id :=
5645: l_hdrtop_rec.tl_object_id;
5646: oks_qpattrib_pvt.g_contract_linrec.invt_org_id :=
5640: oks_qpattrib_pvt.g_contract_linrec.chr_id := l_hdrtop_rec.kh_id;
5641: oks_qpattrib_pvt.g_contract_linrec.top_line_id := l_hdrtop_rec.tl_id;
5642: oks_qpattrib_pvt.g_contract_linrec.cov_line_id :=
5643: l_subline_rec.sl_id;
5644: oks_qpattrib_pvt.g_contract_linrec.inventory_item_id :=
5645: l_hdrtop_rec.tl_object_id;
5646: oks_qpattrib_pvt.g_contract_linrec.invt_org_id :=
5647: l_hdrtop_rec.inv_org;
5648: oks_qpattrib_pvt.g_contract_linrec.auth_org_id :=
5642: oks_qpattrib_pvt.g_contract_linrec.cov_line_id :=
5643: l_subline_rec.sl_id;
5644: oks_qpattrib_pvt.g_contract_linrec.inventory_item_id :=
5645: l_hdrtop_rec.tl_object_id;
5646: oks_qpattrib_pvt.g_contract_linrec.invt_org_id :=
5647: l_hdrtop_rec.inv_org;
5648: oks_qpattrib_pvt.g_contract_linrec.auth_org_id :=
5649: l_hdrtop_rec.kh_auth_org;
5650: oks_qpattrib_pvt.g_contract_linrec.pricing_date :=
5644: oks_qpattrib_pvt.g_contract_linrec.inventory_item_id :=
5645: l_hdrtop_rec.tl_object_id;
5646: oks_qpattrib_pvt.g_contract_linrec.invt_org_id :=
5647: l_hdrtop_rec.inv_org;
5648: oks_qpattrib_pvt.g_contract_linrec.auth_org_id :=
5649: l_hdrtop_rec.kh_auth_org;
5650: oks_qpattrib_pvt.g_contract_linrec.pricing_date :=
5651: l_def_pricing_date;
5652: oks_qpattrib_pvt.g_contract_linrec.party_id := l_party_id;
5646: oks_qpattrib_pvt.g_contract_linrec.invt_org_id :=
5647: l_hdrtop_rec.inv_org;
5648: oks_qpattrib_pvt.g_contract_linrec.auth_org_id :=
5649: l_hdrtop_rec.kh_auth_org;
5650: oks_qpattrib_pvt.g_contract_linrec.pricing_date :=
5651: l_def_pricing_date;
5652: oks_qpattrib_pvt.g_contract_linrec.party_id := l_party_id;
5653: oks_qpattrib_pvt.g_contract_linrec.customer_id := l_customer_id;
5654: oks_qpattrib_pvt.g_contract_linrec.bill_to :=
5648: oks_qpattrib_pvt.g_contract_linrec.auth_org_id :=
5649: l_hdrtop_rec.kh_auth_org;
5650: oks_qpattrib_pvt.g_contract_linrec.pricing_date :=
5651: l_def_pricing_date;
5652: oks_qpattrib_pvt.g_contract_linrec.party_id := l_party_id;
5653: oks_qpattrib_pvt.g_contract_linrec.customer_id := l_customer_id;
5654: oks_qpattrib_pvt.g_contract_linrec.bill_to :=
5655: l_hdrtop_rec.tl_bill_to;
5656: oks_qpattrib_pvt.g_contract_linrec.ship_to :=
5649: l_hdrtop_rec.kh_auth_org;
5650: oks_qpattrib_pvt.g_contract_linrec.pricing_date :=
5651: l_def_pricing_date;
5652: oks_qpattrib_pvt.g_contract_linrec.party_id := l_party_id;
5653: oks_qpattrib_pvt.g_contract_linrec.customer_id := l_customer_id;
5654: oks_qpattrib_pvt.g_contract_linrec.bill_to :=
5655: l_hdrtop_rec.tl_bill_to;
5656: oks_qpattrib_pvt.g_contract_linrec.ship_to :=
5657: l_hdrtop_rec.tl_ship_to;
5650: oks_qpattrib_pvt.g_contract_linrec.pricing_date :=
5651: l_def_pricing_date;
5652: oks_qpattrib_pvt.g_contract_linrec.party_id := l_party_id;
5653: oks_qpattrib_pvt.g_contract_linrec.customer_id := l_customer_id;
5654: oks_qpattrib_pvt.g_contract_linrec.bill_to :=
5655: l_hdrtop_rec.tl_bill_to;
5656: oks_qpattrib_pvt.g_contract_linrec.ship_to :=
5657: l_hdrtop_rec.tl_ship_to;
5658: oks_qpattrib_pvt.g_contract_linrec.payment_term_id :=
5652: oks_qpattrib_pvt.g_contract_linrec.party_id := l_party_id;
5653: oks_qpattrib_pvt.g_contract_linrec.customer_id := l_customer_id;
5654: oks_qpattrib_pvt.g_contract_linrec.bill_to :=
5655: l_hdrtop_rec.tl_bill_to;
5656: oks_qpattrib_pvt.g_contract_linrec.ship_to :=
5657: l_hdrtop_rec.tl_ship_to;
5658: oks_qpattrib_pvt.g_contract_linrec.payment_term_id :=
5659: l_hdrtop_rec.tl_payment_term_id;
5660: END IF;
5654: oks_qpattrib_pvt.g_contract_linrec.bill_to :=
5655: l_hdrtop_rec.tl_bill_to;
5656: oks_qpattrib_pvt.g_contract_linrec.ship_to :=
5657: l_hdrtop_rec.tl_ship_to;
5658: oks_qpattrib_pvt.g_contract_linrec.payment_term_id :=
5659: l_hdrtop_rec.tl_payment_term_id;
5660: END IF;
5661:
5662: IF p_detail_rec.break_uom_code IS NOT NULL
5660: END IF;
5661:
5662: IF p_detail_rec.break_uom_code IS NOT NULL
5663: THEN
5664: oks_qpattrib_pvt.g_contract_linrec.break_uom :=
5665: p_detail_rec.break_uom_code;
5666: ELSE
5667: oks_qpattrib_pvt.g_contract_linrec.break_uom := NULL;
5668: END IF;
5663: THEN
5664: oks_qpattrib_pvt.g_contract_linrec.break_uom :=
5665: p_detail_rec.break_uom_code;
5666: ELSE
5667: oks_qpattrib_pvt.g_contract_linrec.break_uom := NULL;
5668: END IF;
5669:
5670: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
5671: THEN
5672: fnd_log.STRING (fnd_log.level_procedure,
5673: g_module ||
5674: l_api_name,
5675: '2001:*** GLOBAL VARIABLE - CHR-ID **** ' ||
5676: oks_qpattrib_pvt.g_contract_hdrrec.chr_id
5677: );
5678: fnd_log.STRING (fnd_log.level_procedure,
5679: g_module ||
5680: l_api_name,
5678: fnd_log.STRING (fnd_log.level_procedure,
5679: g_module ||
5680: l_api_name,
5681: '2002:*** GLOBAL VARIABLE - TOP-LINE ID **** ' ||
5682: oks_qpattrib_pvt.g_contract_hdrrec.top_line_id
5683: );
5684: fnd_log.STRING (fnd_log.level_procedure,
5685: g_module ||
5686: l_api_name,
5684: fnd_log.STRING (fnd_log.level_procedure,
5685: g_module ||
5686: l_api_name,
5687: '2003:*** GLOBAL VARIABLE - COV-LINE-ID **** ' ||
5688: oks_qpattrib_pvt.g_contract_hdrrec.cov_line_id
5689: );
5690: fnd_log.STRING (fnd_log.level_procedure,
5691: g_module ||
5692: l_api_name,
5690: fnd_log.STRING (fnd_log.level_procedure,
5691: g_module ||
5692: l_api_name,
5693: '2004:*** GLOBAL VARIABLE - INV-ITEM-ID **** ' ||
5694: oks_qpattrib_pvt.g_contract_hdrrec.inventory_item_id
5695: );
5696: fnd_log.STRING (fnd_log.level_procedure,
5697: g_module ||
5698: l_api_name,
5696: fnd_log.STRING (fnd_log.level_procedure,
5697: g_module ||
5698: l_api_name,
5699: '2005:*** GLOBAL VARIABLE - INV- ORG-ID **** ' ||
5700: oks_qpattrib_pvt.g_contract_hdrrec.invt_org_id
5701: );
5702: fnd_log.STRING (fnd_log.level_procedure,
5703: g_module ||
5704: l_api_name,
5702: fnd_log.STRING (fnd_log.level_procedure,
5703: g_module ||
5704: l_api_name,
5705: '2006:*** GLOBAL VARIABLE - AUT- ORG-ID **** ' ||
5706: oks_qpattrib_pvt.g_contract_hdrrec.auth_org_id
5707: );
5708: fnd_log.STRING (fnd_log.level_procedure,
5709: g_module ||
5710: l_api_name,
5708: fnd_log.STRING (fnd_log.level_procedure,
5709: g_module ||
5710: l_api_name,
5711: '2007:*** GLOBAL VARIABLE - PRICE -DATE **** ' ||
5712: oks_qpattrib_pvt.g_contract_hdrrec.pricing_date
5713: );
5714: fnd_log.STRING (fnd_log.level_procedure,
5715: g_module ||
5716: l_api_name,
5714: fnd_log.STRING (fnd_log.level_procedure,
5715: g_module ||
5716: l_api_name,
5717: '2008:*** GLOBAL VARIABLE - PARTY - ID **** ' ||
5718: oks_qpattrib_pvt.g_contract_hdrrec.party_id
5719: );
5720: fnd_log.STRING (fnd_log.level_procedure,
5721: g_module ||
5722: l_api_name,
5720: fnd_log.STRING (fnd_log.level_procedure,
5721: g_module ||
5722: l_api_name,
5723: '2009:*** GLOBAL VARIABLE - CUST - ID **** ' ||
5724: oks_qpattrib_pvt.g_contract_hdrrec.customer_id
5725: );
5726: fnd_log.STRING (fnd_log.level_procedure,
5727: g_module ||
5728: l_api_name,
5726: fnd_log.STRING (fnd_log.level_procedure,
5727: g_module ||
5728: l_api_name,
5729: '2010:*** GLOBAL VARIABLE - AGREEM- ID **** ' ||
5730: oks_qpattrib_pvt.g_contract_hdrrec.agreement_id
5731: );
5732: fnd_log.STRING (fnd_log.level_procedure,
5733: g_module ||
5734: l_api_name,
5732: fnd_log.STRING (fnd_log.level_procedure,
5733: g_module ||
5734: l_api_name,
5735: '2011:*** GLOBAL VARIABLE - BILL - TO **** ' ||
5736: oks_qpattrib_pvt.g_contract_hdrrec.bill_to
5737: );
5738: fnd_log.STRING (fnd_log.level_procedure,
5739: g_module ||
5740: l_api_name,
5738: fnd_log.STRING (fnd_log.level_procedure,
5739: g_module ||
5740: l_api_name,
5741: '2012:*** GLOBAL VARIABLE - SHIP - TO **** ' ||
5742: oks_qpattrib_pvt.g_contract_hdrrec.ship_to
5743: );
5744: fnd_log.STRING (fnd_log.level_procedure,
5745: g_module ||
5746: l_api_name,
5744: fnd_log.STRING (fnd_log.level_procedure,
5745: g_module ||
5746: l_api_name,
5747: '2013:*** GLOBAL VARIABLE - PAYMENT ID **** ' ||
5748: oks_qpattrib_pvt.g_contract_hdrrec.payment_term_id
5749: );
5750: fnd_log.STRING (fnd_log.level_procedure,
5751: g_module ||
5752: l_api_name,
5750: fnd_log.STRING (fnd_log.level_procedure,
5751: g_module ||
5752: l_api_name,
5753: '2014:*** GLOBAL VARIABLE - BREAK UOM **** ' ||
5754: oks_qpattrib_pvt.g_contract_hdrrec.break_uom
5755: );
5756: fnd_log.STRING (fnd_log.level_procedure,
5757: g_module ||
5758: l_api_name,
5756: fnd_log.STRING (fnd_log.level_procedure,
5757: g_module ||
5758: l_api_name,
5759: '2015:*** GLOBAL VARIABLE - CHR-ID **** ' ||
5760: oks_qpattrib_pvt.g_contract_linrec.chr_id
5761: );
5762: fnd_log.STRING (fnd_log.level_procedure,
5763: g_module ||
5764: l_api_name,
5762: fnd_log.STRING (fnd_log.level_procedure,
5763: g_module ||
5764: l_api_name,
5765: '2016:*** GLOBAL VARIABLE - TOP-LINE ID **** ' ||
5766: oks_qpattrib_pvt.g_contract_linrec.top_line_id
5767: );
5768: fnd_log.STRING (fnd_log.level_procedure,
5769: g_module ||
5770: l_api_name,
5768: fnd_log.STRING (fnd_log.level_procedure,
5769: g_module ||
5770: l_api_name,
5771: '2017:*** GLOBAL VARIABLE - COV-LINE-ID **** ' ||
5772: oks_qpattrib_pvt.g_contract_linrec.cov_line_id
5773: );
5774: fnd_log.STRING (fnd_log.level_procedure,
5775: g_module ||
5776: l_api_name,
5774: fnd_log.STRING (fnd_log.level_procedure,
5775: g_module ||
5776: l_api_name,
5777: '2018:*** GLOBAL VARIABLE - INV-ITEM-ID **** ' ||
5778: oks_qpattrib_pvt.g_contract_linrec.inventory_item_id
5779: );
5780: fnd_log.STRING (fnd_log.level_procedure,
5781: g_module ||
5782: l_api_name,
5780: fnd_log.STRING (fnd_log.level_procedure,
5781: g_module ||
5782: l_api_name,
5783: '2019:*** GLOBAL VARIABLE - INV- ORG-ID **** ' ||
5784: oks_qpattrib_pvt.g_contract_linrec.invt_org_id
5785: );
5786: fnd_log.STRING (fnd_log.level_procedure,
5787: g_module ||
5788: l_api_name,
5786: fnd_log.STRING (fnd_log.level_procedure,
5787: g_module ||
5788: l_api_name,
5789: '2020:*** GLOBAL VARIABLE - AUT- ORG-ID **** ' ||
5790: oks_qpattrib_pvt.g_contract_linrec.auth_org_id
5791: );
5792: fnd_log.STRING (fnd_log.level_procedure,
5793: g_module ||
5794: l_api_name,
5792: fnd_log.STRING (fnd_log.level_procedure,
5793: g_module ||
5794: l_api_name,
5795: '2021:*** GLOBAL VARIABLE - PRICE -DATE **** ' ||
5796: oks_qpattrib_pvt.g_contract_linrec.pricing_date
5797: );
5798: fnd_log.STRING (fnd_log.level_procedure,
5799: g_module ||
5800: l_api_name,
5798: fnd_log.STRING (fnd_log.level_procedure,
5799: g_module ||
5800: l_api_name,
5801: '2022:*** GLOBAL VARIABLE - PARTY - ID **** ' ||
5802: oks_qpattrib_pvt.g_contract_linrec.party_id
5803: );
5804: fnd_log.STRING (fnd_log.level_procedure,
5805: g_module ||
5806: l_api_name,
5804: fnd_log.STRING (fnd_log.level_procedure,
5805: g_module ||
5806: l_api_name,
5807: '2023:*** GLOBAL VARIABLE - CUST - ID **** ' ||
5808: oks_qpattrib_pvt.g_contract_linrec.customer_id
5809: );
5810: fnd_log.STRING (fnd_log.level_procedure,
5811: g_module ||
5812: l_api_name,
5810: fnd_log.STRING (fnd_log.level_procedure,
5811: g_module ||
5812: l_api_name,
5813: '2024:*** GLOBAL VARIABLE - BREAK UOM **** ' ||
5814: oks_qpattrib_pvt.g_contract_linrec.break_uom
5815: );
5816: fnd_log.STRING (fnd_log.level_procedure,
5817: g_module ||
5818: l_api_name,
5816: fnd_log.STRING (fnd_log.level_procedure,
5817: g_module ||
5818: l_api_name,
5819: '2025:*** GLOBAL VARIABLE - BILL - TO **** ' ||
5820: oks_qpattrib_pvt.g_contract_linrec.bill_to
5821: );
5822: fnd_log.STRING (fnd_log.level_procedure,
5823: g_module ||
5824: l_api_name,
5822: fnd_log.STRING (fnd_log.level_procedure,
5823: g_module ||
5824: l_api_name,
5825: '2026:*** GLOBAL VARIABLE - SHIP - TO **** ' ||
5826: oks_qpattrib_pvt.g_contract_linrec.ship_to
5827: );
5828: fnd_log.STRING (fnd_log.level_procedure,
5829: g_module ||
5830: l_api_name,
5828: fnd_log.STRING (fnd_log.level_procedure,
5829: g_module ||
5830: l_api_name,
5831: '2027:*** GLOBAL VARIABLE - PAYMENT ID **** ' ||
5832: oks_qpattrib_pvt.g_contract_linrec.payment_term_id
5833: );
5834: fnd_log.STRING (fnd_log.level_procedure,
5835: g_module ||
5836: l_api_name,
5834: fnd_log.STRING (fnd_log.level_procedure,
5835: g_module ||
5836: l_api_name,
5837: '2028:*** GLOBAL VARIABLE - BREAK UOM **** ' ||
5838: oks_qpattrib_pvt.g_contract_linrec.break_uom
5839: );
5840: END IF;
5841:
5842: --dbms_output.put_line ('*** GLOBAL VARIABLE - CHR-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.CHR_ID);
5838: oks_qpattrib_pvt.g_contract_linrec.break_uom
5839: );
5840: END IF;
5841:
5842: --dbms_output.put_line ('*** GLOBAL VARIABLE - CHR-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.CHR_ID);
5843: --dbms_output.put_line ('*** GLOBAL VARIABLE - TOP-LINE ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.TOP_LINE_ID);
5844: --dbms_output.put_line ('*** GLOBAL VARIABLE - COV-LINE-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.COV_LINE_ID);
5845: --dbms_output.put_line ('*** GLOBAL VARIABLE - INV-ITEM-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.INVENTORY_ITEM_ID);
5846: --dbms_output.put_line ('*** GLOBAL VARIABLE - INV- ORG-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.INVT_ORG_ID);
5839: );
5840: END IF;
5841:
5842: --dbms_output.put_line ('*** GLOBAL VARIABLE - CHR-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.CHR_ID);
5843: --dbms_output.put_line ('*** GLOBAL VARIABLE - TOP-LINE ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.TOP_LINE_ID);
5844: --dbms_output.put_line ('*** GLOBAL VARIABLE - COV-LINE-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.COV_LINE_ID);
5845: --dbms_output.put_line ('*** GLOBAL VARIABLE - INV-ITEM-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.INVENTORY_ITEM_ID);
5846: --dbms_output.put_line ('*** GLOBAL VARIABLE - INV- ORG-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.INVT_ORG_ID);
5847: --dbms_output.put_line ('*** GLOBAL VARIABLE - AUT- ORG-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.AUTH_ORG_ID);
5840: END IF;
5841:
5842: --dbms_output.put_line ('*** GLOBAL VARIABLE - CHR-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.CHR_ID);
5843: --dbms_output.put_line ('*** GLOBAL VARIABLE - TOP-LINE ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.TOP_LINE_ID);
5844: --dbms_output.put_line ('*** GLOBAL VARIABLE - COV-LINE-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.COV_LINE_ID);
5845: --dbms_output.put_line ('*** GLOBAL VARIABLE - INV-ITEM-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.INVENTORY_ITEM_ID);
5846: --dbms_output.put_line ('*** GLOBAL VARIABLE - INV- ORG-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.INVT_ORG_ID);
5847: --dbms_output.put_line ('*** GLOBAL VARIABLE - AUT- ORG-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.AUTH_ORG_ID);
5848: --dbms_output.put_line ('*** GLOBAL VARIABLE - PRICE -DATE **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.PRICING_DATE);
5841:
5842: --dbms_output.put_line ('*** GLOBAL VARIABLE - CHR-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.CHR_ID);
5843: --dbms_output.put_line ('*** GLOBAL VARIABLE - TOP-LINE ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.TOP_LINE_ID);
5844: --dbms_output.put_line ('*** GLOBAL VARIABLE - COV-LINE-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.COV_LINE_ID);
5845: --dbms_output.put_line ('*** GLOBAL VARIABLE - INV-ITEM-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.INVENTORY_ITEM_ID);
5846: --dbms_output.put_line ('*** GLOBAL VARIABLE - INV- ORG-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.INVT_ORG_ID);
5847: --dbms_output.put_line ('*** GLOBAL VARIABLE - AUT- ORG-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.AUTH_ORG_ID);
5848: --dbms_output.put_line ('*** GLOBAL VARIABLE - PRICE -DATE **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.PRICING_DATE);
5849: --dbms_output.put_line ('*** GLOBAL VARIABLE - PARTY - ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.PARTY_ID);
5842: --dbms_output.put_line ('*** GLOBAL VARIABLE - CHR-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.CHR_ID);
5843: --dbms_output.put_line ('*** GLOBAL VARIABLE - TOP-LINE ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.TOP_LINE_ID);
5844: --dbms_output.put_line ('*** GLOBAL VARIABLE - COV-LINE-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.COV_LINE_ID);
5845: --dbms_output.put_line ('*** GLOBAL VARIABLE - INV-ITEM-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.INVENTORY_ITEM_ID);
5846: --dbms_output.put_line ('*** GLOBAL VARIABLE - INV- ORG-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.INVT_ORG_ID);
5847: --dbms_output.put_line ('*** GLOBAL VARIABLE - AUT- ORG-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.AUTH_ORG_ID);
5848: --dbms_output.put_line ('*** GLOBAL VARIABLE - PRICE -DATE **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.PRICING_DATE);
5849: --dbms_output.put_line ('*** GLOBAL VARIABLE - PARTY - ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.PARTY_ID);
5850: --dbms_output.put_line ('*** GLOBAL VARIABLE - CUST - ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.CUSTOMER_ID);
5843: --dbms_output.put_line ('*** GLOBAL VARIABLE - TOP-LINE ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.TOP_LINE_ID);
5844: --dbms_output.put_line ('*** GLOBAL VARIABLE - COV-LINE-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.COV_LINE_ID);
5845: --dbms_output.put_line ('*** GLOBAL VARIABLE - INV-ITEM-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.INVENTORY_ITEM_ID);
5846: --dbms_output.put_line ('*** GLOBAL VARIABLE - INV- ORG-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.INVT_ORG_ID);
5847: --dbms_output.put_line ('*** GLOBAL VARIABLE - AUT- ORG-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.AUTH_ORG_ID);
5848: --dbms_output.put_line ('*** GLOBAL VARIABLE - PRICE -DATE **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.PRICING_DATE);
5849: --dbms_output.put_line ('*** GLOBAL VARIABLE - PARTY - ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.PARTY_ID);
5850: --dbms_output.put_line ('*** GLOBAL VARIABLE - CUST - ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.CUSTOMER_ID);
5851: --dbms_output.put_line ('*** GLOBAL VARIABLE - AGREEM- ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.AGREEMENT_ID);
5844: --dbms_output.put_line ('*** GLOBAL VARIABLE - COV-LINE-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.COV_LINE_ID);
5845: --dbms_output.put_line ('*** GLOBAL VARIABLE - INV-ITEM-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.INVENTORY_ITEM_ID);
5846: --dbms_output.put_line ('*** GLOBAL VARIABLE - INV- ORG-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.INVT_ORG_ID);
5847: --dbms_output.put_line ('*** GLOBAL VARIABLE - AUT- ORG-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.AUTH_ORG_ID);
5848: --dbms_output.put_line ('*** GLOBAL VARIABLE - PRICE -DATE **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.PRICING_DATE);
5849: --dbms_output.put_line ('*** GLOBAL VARIABLE - PARTY - ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.PARTY_ID);
5850: --dbms_output.put_line ('*** GLOBAL VARIABLE - CUST - ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.CUSTOMER_ID);
5851: --dbms_output.put_line ('*** GLOBAL VARIABLE - AGREEM- ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.AGREEMENT_ID);
5852: --dbms_output.put_line ('*** GLOBAL VARIABLE - BILL - TO **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.BILL_TO);
5845: --dbms_output.put_line ('*** GLOBAL VARIABLE - INV-ITEM-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.INVENTORY_ITEM_ID);
5846: --dbms_output.put_line ('*** GLOBAL VARIABLE - INV- ORG-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.INVT_ORG_ID);
5847: --dbms_output.put_line ('*** GLOBAL VARIABLE - AUT- ORG-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.AUTH_ORG_ID);
5848: --dbms_output.put_line ('*** GLOBAL VARIABLE - PRICE -DATE **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.PRICING_DATE);
5849: --dbms_output.put_line ('*** GLOBAL VARIABLE - PARTY - ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.PARTY_ID);
5850: --dbms_output.put_line ('*** GLOBAL VARIABLE - CUST - ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.CUSTOMER_ID);
5851: --dbms_output.put_line ('*** GLOBAL VARIABLE - AGREEM- ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.AGREEMENT_ID);
5852: --dbms_output.put_line ('*** GLOBAL VARIABLE - BILL - TO **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.BILL_TO);
5853: --dbms_output.put_line ('*** GLOBAL VARIABLE - SHIP - TO **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.SHIP_TO);
5846: --dbms_output.put_line ('*** GLOBAL VARIABLE - INV- ORG-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.INVT_ORG_ID);
5847: --dbms_output.put_line ('*** GLOBAL VARIABLE - AUT- ORG-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.AUTH_ORG_ID);
5848: --dbms_output.put_line ('*** GLOBAL VARIABLE - PRICE -DATE **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.PRICING_DATE);
5849: --dbms_output.put_line ('*** GLOBAL VARIABLE - PARTY - ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.PARTY_ID);
5850: --dbms_output.put_line ('*** GLOBAL VARIABLE - CUST - ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.CUSTOMER_ID);
5851: --dbms_output.put_line ('*** GLOBAL VARIABLE - AGREEM- ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.AGREEMENT_ID);
5852: --dbms_output.put_line ('*** GLOBAL VARIABLE - BILL - TO **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.BILL_TO);
5853: --dbms_output.put_line ('*** GLOBAL VARIABLE - SHIP - TO **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.SHIP_TO);
5854: --dbms_output.put_line ('*** GLOBAL VARIABLE - PAYMENT ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.PAYMENT_TERM_ID);
5847: --dbms_output.put_line ('*** GLOBAL VARIABLE - AUT- ORG-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.AUTH_ORG_ID);
5848: --dbms_output.put_line ('*** GLOBAL VARIABLE - PRICE -DATE **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.PRICING_DATE);
5849: --dbms_output.put_line ('*** GLOBAL VARIABLE - PARTY - ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.PARTY_ID);
5850: --dbms_output.put_line ('*** GLOBAL VARIABLE - CUST - ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.CUSTOMER_ID);
5851: --dbms_output.put_line ('*** GLOBAL VARIABLE - AGREEM- ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.AGREEMENT_ID);
5852: --dbms_output.put_line ('*** GLOBAL VARIABLE - BILL - TO **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.BILL_TO);
5853: --dbms_output.put_line ('*** GLOBAL VARIABLE - SHIP - TO **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.SHIP_TO);
5854: --dbms_output.put_line ('*** GLOBAL VARIABLE - PAYMENT ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.PAYMENT_TERM_ID);
5855: --dbms_output.put_line ('*** GLOBAL VARIABLE - BREAK UOM **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.BREAK_UOM);
5848: --dbms_output.put_line ('*** GLOBAL VARIABLE - PRICE -DATE **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.PRICING_DATE);
5849: --dbms_output.put_line ('*** GLOBAL VARIABLE - PARTY - ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.PARTY_ID);
5850: --dbms_output.put_line ('*** GLOBAL VARIABLE - CUST - ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.CUSTOMER_ID);
5851: --dbms_output.put_line ('*** GLOBAL VARIABLE - AGREEM- ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.AGREEMENT_ID);
5852: --dbms_output.put_line ('*** GLOBAL VARIABLE - BILL - TO **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.BILL_TO);
5853: --dbms_output.put_line ('*** GLOBAL VARIABLE - SHIP - TO **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.SHIP_TO);
5854: --dbms_output.put_line ('*** GLOBAL VARIABLE - PAYMENT ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.PAYMENT_TERM_ID);
5855: --dbms_output.put_line ('*** GLOBAL VARIABLE - BREAK UOM **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.BREAK_UOM);
5856:
5849: --dbms_output.put_line ('*** GLOBAL VARIABLE - PARTY - ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.PARTY_ID);
5850: --dbms_output.put_line ('*** GLOBAL VARIABLE - CUST - ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.CUSTOMER_ID);
5851: --dbms_output.put_line ('*** GLOBAL VARIABLE - AGREEM- ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.AGREEMENT_ID);
5852: --dbms_output.put_line ('*** GLOBAL VARIABLE - BILL - TO **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.BILL_TO);
5853: --dbms_output.put_line ('*** GLOBAL VARIABLE - SHIP - TO **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.SHIP_TO);
5854: --dbms_output.put_line ('*** GLOBAL VARIABLE - PAYMENT ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.PAYMENT_TERM_ID);
5855: --dbms_output.put_line ('*** GLOBAL VARIABLE - BREAK UOM **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.BREAK_UOM);
5856:
5857: --dbms_output.put_line ('*** GLOBAL VARIABLE - CHR-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.CHR_ID);
5850: --dbms_output.put_line ('*** GLOBAL VARIABLE - CUST - ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.CUSTOMER_ID);
5851: --dbms_output.put_line ('*** GLOBAL VARIABLE - AGREEM- ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.AGREEMENT_ID);
5852: --dbms_output.put_line ('*** GLOBAL VARIABLE - BILL - TO **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.BILL_TO);
5853: --dbms_output.put_line ('*** GLOBAL VARIABLE - SHIP - TO **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.SHIP_TO);
5854: --dbms_output.put_line ('*** GLOBAL VARIABLE - PAYMENT ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.PAYMENT_TERM_ID);
5855: --dbms_output.put_line ('*** GLOBAL VARIABLE - BREAK UOM **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.BREAK_UOM);
5856:
5857: --dbms_output.put_line ('*** GLOBAL VARIABLE - CHR-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.CHR_ID);
5858: --dbms_output.put_line ('*** GLOBAL VARIABLE - TOP-LINE ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.TOP_LINE_ID);
5851: --dbms_output.put_line ('*** GLOBAL VARIABLE - AGREEM- ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.AGREEMENT_ID);
5852: --dbms_output.put_line ('*** GLOBAL VARIABLE - BILL - TO **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.BILL_TO);
5853: --dbms_output.put_line ('*** GLOBAL VARIABLE - SHIP - TO **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.SHIP_TO);
5854: --dbms_output.put_line ('*** GLOBAL VARIABLE - PAYMENT ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.PAYMENT_TERM_ID);
5855: --dbms_output.put_line ('*** GLOBAL VARIABLE - BREAK UOM **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.BREAK_UOM);
5856:
5857: --dbms_output.put_line ('*** GLOBAL VARIABLE - CHR-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.CHR_ID);
5858: --dbms_output.put_line ('*** GLOBAL VARIABLE - TOP-LINE ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.TOP_LINE_ID);
5859: --dbms_output.put_line ('*** GLOBAL VARIABLE - COV-LINE-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.COV_LINE_ID);
5853: --dbms_output.put_line ('*** GLOBAL VARIABLE - SHIP - TO **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.SHIP_TO);
5854: --dbms_output.put_line ('*** GLOBAL VARIABLE - PAYMENT ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.PAYMENT_TERM_ID);
5855: --dbms_output.put_line ('*** GLOBAL VARIABLE - BREAK UOM **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.BREAK_UOM);
5856:
5857: --dbms_output.put_line ('*** GLOBAL VARIABLE - CHR-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.CHR_ID);
5858: --dbms_output.put_line ('*** GLOBAL VARIABLE - TOP-LINE ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.TOP_LINE_ID);
5859: --dbms_output.put_line ('*** GLOBAL VARIABLE - COV-LINE-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.COV_LINE_ID);
5860: --dbms_output.put_line ('*** GLOBAL VARIABLE - INV-ITEM-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.INVENTORY_ITEM_ID);
5861: --dbms_output.put_line ('*** GLOBAL VARIABLE - INV- ORG-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.INVT_ORG_ID);
5854: --dbms_output.put_line ('*** GLOBAL VARIABLE - PAYMENT ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.PAYMENT_TERM_ID);
5855: --dbms_output.put_line ('*** GLOBAL VARIABLE - BREAK UOM **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.BREAK_UOM);
5856:
5857: --dbms_output.put_line ('*** GLOBAL VARIABLE - CHR-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.CHR_ID);
5858: --dbms_output.put_line ('*** GLOBAL VARIABLE - TOP-LINE ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.TOP_LINE_ID);
5859: --dbms_output.put_line ('*** GLOBAL VARIABLE - COV-LINE-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.COV_LINE_ID);
5860: --dbms_output.put_line ('*** GLOBAL VARIABLE - INV-ITEM-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.INVENTORY_ITEM_ID);
5861: --dbms_output.put_line ('*** GLOBAL VARIABLE - INV- ORG-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.INVT_ORG_ID);
5862: --dbms_output.put_line ('*** GLOBAL VARIABLE - AUT- ORG-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.AUTH_ORG_ID);
5855: --dbms_output.put_line ('*** GLOBAL VARIABLE - BREAK UOM **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_HDRREC.BREAK_UOM);
5856:
5857: --dbms_output.put_line ('*** GLOBAL VARIABLE - CHR-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.CHR_ID);
5858: --dbms_output.put_line ('*** GLOBAL VARIABLE - TOP-LINE ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.TOP_LINE_ID);
5859: --dbms_output.put_line ('*** GLOBAL VARIABLE - COV-LINE-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.COV_LINE_ID);
5860: --dbms_output.put_line ('*** GLOBAL VARIABLE - INV-ITEM-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.INVENTORY_ITEM_ID);
5861: --dbms_output.put_line ('*** GLOBAL VARIABLE - INV- ORG-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.INVT_ORG_ID);
5862: --dbms_output.put_line ('*** GLOBAL VARIABLE - AUT- ORG-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.AUTH_ORG_ID);
5863: --dbms_output.put_line ('*** GLOBAL VARIABLE - PRICE -DATE **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.PRICING_DATE);
5856:
5857: --dbms_output.put_line ('*** GLOBAL VARIABLE - CHR-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.CHR_ID);
5858: --dbms_output.put_line ('*** GLOBAL VARIABLE - TOP-LINE ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.TOP_LINE_ID);
5859: --dbms_output.put_line ('*** GLOBAL VARIABLE - COV-LINE-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.COV_LINE_ID);
5860: --dbms_output.put_line ('*** GLOBAL VARIABLE - INV-ITEM-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.INVENTORY_ITEM_ID);
5861: --dbms_output.put_line ('*** GLOBAL VARIABLE - INV- ORG-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.INVT_ORG_ID);
5862: --dbms_output.put_line ('*** GLOBAL VARIABLE - AUT- ORG-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.AUTH_ORG_ID);
5863: --dbms_output.put_line ('*** GLOBAL VARIABLE - PRICE -DATE **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.PRICING_DATE);
5864: --dbms_output.put_line ('*** GLOBAL VARIABLE - PARTY - ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.PARTY_ID);
5857: --dbms_output.put_line ('*** GLOBAL VARIABLE - CHR-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.CHR_ID);
5858: --dbms_output.put_line ('*** GLOBAL VARIABLE - TOP-LINE ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.TOP_LINE_ID);
5859: --dbms_output.put_line ('*** GLOBAL VARIABLE - COV-LINE-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.COV_LINE_ID);
5860: --dbms_output.put_line ('*** GLOBAL VARIABLE - INV-ITEM-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.INVENTORY_ITEM_ID);
5861: --dbms_output.put_line ('*** GLOBAL VARIABLE - INV- ORG-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.INVT_ORG_ID);
5862: --dbms_output.put_line ('*** GLOBAL VARIABLE - AUT- ORG-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.AUTH_ORG_ID);
5863: --dbms_output.put_line ('*** GLOBAL VARIABLE - PRICE -DATE **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.PRICING_DATE);
5864: --dbms_output.put_line ('*** GLOBAL VARIABLE - PARTY - ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.PARTY_ID);
5865: --dbms_output.put_line ('*** GLOBAL VARIABLE - CUST - ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.CUSTOMER_ID);
5858: --dbms_output.put_line ('*** GLOBAL VARIABLE - TOP-LINE ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.TOP_LINE_ID);
5859: --dbms_output.put_line ('*** GLOBAL VARIABLE - COV-LINE-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.COV_LINE_ID);
5860: --dbms_output.put_line ('*** GLOBAL VARIABLE - INV-ITEM-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.INVENTORY_ITEM_ID);
5861: --dbms_output.put_line ('*** GLOBAL VARIABLE - INV- ORG-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.INVT_ORG_ID);
5862: --dbms_output.put_line ('*** GLOBAL VARIABLE - AUT- ORG-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.AUTH_ORG_ID);
5863: --dbms_output.put_line ('*** GLOBAL VARIABLE - PRICE -DATE **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.PRICING_DATE);
5864: --dbms_output.put_line ('*** GLOBAL VARIABLE - PARTY - ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.PARTY_ID);
5865: --dbms_output.put_line ('*** GLOBAL VARIABLE - CUST - ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.CUSTOMER_ID);
5866: --dbms_output.put_line ('*** GLOBAL VARIABLE - BREAK UOM **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.BREAK_UOM);
5859: --dbms_output.put_line ('*** GLOBAL VARIABLE - COV-LINE-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.COV_LINE_ID);
5860: --dbms_output.put_line ('*** GLOBAL VARIABLE - INV-ITEM-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.INVENTORY_ITEM_ID);
5861: --dbms_output.put_line ('*** GLOBAL VARIABLE - INV- ORG-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.INVT_ORG_ID);
5862: --dbms_output.put_line ('*** GLOBAL VARIABLE - AUT- ORG-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.AUTH_ORG_ID);
5863: --dbms_output.put_line ('*** GLOBAL VARIABLE - PRICE -DATE **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.PRICING_DATE);
5864: --dbms_output.put_line ('*** GLOBAL VARIABLE - PARTY - ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.PARTY_ID);
5865: --dbms_output.put_line ('*** GLOBAL VARIABLE - CUST - ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.CUSTOMER_ID);
5866: --dbms_output.put_line ('*** GLOBAL VARIABLE - BREAK UOM **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.BREAK_UOM);
5867: --dbms_output.put_line ('*** GLOBAL VARIABLE - BILL - TO **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.BILL_TO);
5860: --dbms_output.put_line ('*** GLOBAL VARIABLE - INV-ITEM-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.INVENTORY_ITEM_ID);
5861: --dbms_output.put_line ('*** GLOBAL VARIABLE - INV- ORG-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.INVT_ORG_ID);
5862: --dbms_output.put_line ('*** GLOBAL VARIABLE - AUT- ORG-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.AUTH_ORG_ID);
5863: --dbms_output.put_line ('*** GLOBAL VARIABLE - PRICE -DATE **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.PRICING_DATE);
5864: --dbms_output.put_line ('*** GLOBAL VARIABLE - PARTY - ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.PARTY_ID);
5865: --dbms_output.put_line ('*** GLOBAL VARIABLE - CUST - ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.CUSTOMER_ID);
5866: --dbms_output.put_line ('*** GLOBAL VARIABLE - BREAK UOM **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.BREAK_UOM);
5867: --dbms_output.put_line ('*** GLOBAL VARIABLE - BILL - TO **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.BILL_TO);
5868: --dbms_output.put_line ('*** GLOBAL VARIABLE - SHIP - TO **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.SHIP_TO);
5861: --dbms_output.put_line ('*** GLOBAL VARIABLE - INV- ORG-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.INVT_ORG_ID);
5862: --dbms_output.put_line ('*** GLOBAL VARIABLE - AUT- ORG-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.AUTH_ORG_ID);
5863: --dbms_output.put_line ('*** GLOBAL VARIABLE - PRICE -DATE **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.PRICING_DATE);
5864: --dbms_output.put_line ('*** GLOBAL VARIABLE - PARTY - ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.PARTY_ID);
5865: --dbms_output.put_line ('*** GLOBAL VARIABLE - CUST - ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.CUSTOMER_ID);
5866: --dbms_output.put_line ('*** GLOBAL VARIABLE - BREAK UOM **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.BREAK_UOM);
5867: --dbms_output.put_line ('*** GLOBAL VARIABLE - BILL - TO **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.BILL_TO);
5868: --dbms_output.put_line ('*** GLOBAL VARIABLE - SHIP - TO **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.SHIP_TO);
5869: --dbms_output.put_line ('*** GLOBAL VARIABLE - PAYMENT ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.PAYMENT_TERM_ID);
5862: --dbms_output.put_line ('*** GLOBAL VARIABLE - AUT- ORG-ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.AUTH_ORG_ID);
5863: --dbms_output.put_line ('*** GLOBAL VARIABLE - PRICE -DATE **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.PRICING_DATE);
5864: --dbms_output.put_line ('*** GLOBAL VARIABLE - PARTY - ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.PARTY_ID);
5865: --dbms_output.put_line ('*** GLOBAL VARIABLE - CUST - ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.CUSTOMER_ID);
5866: --dbms_output.put_line ('*** GLOBAL VARIABLE - BREAK UOM **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.BREAK_UOM);
5867: --dbms_output.put_line ('*** GLOBAL VARIABLE - BILL - TO **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.BILL_TO);
5868: --dbms_output.put_line ('*** GLOBAL VARIABLE - SHIP - TO **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.SHIP_TO);
5869: --dbms_output.put_line ('*** GLOBAL VARIABLE - PAYMENT ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.PAYMENT_TERM_ID);
5870: --dbms_output.put_line ('*** GLOBAL VARIABLE - BREAK UOM **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.BREAK_UOM);
5863: --dbms_output.put_line ('*** GLOBAL VARIABLE - PRICE -DATE **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.PRICING_DATE);
5864: --dbms_output.put_line ('*** GLOBAL VARIABLE - PARTY - ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.PARTY_ID);
5865: --dbms_output.put_line ('*** GLOBAL VARIABLE - CUST - ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.CUSTOMER_ID);
5866: --dbms_output.put_line ('*** GLOBAL VARIABLE - BREAK UOM **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.BREAK_UOM);
5867: --dbms_output.put_line ('*** GLOBAL VARIABLE - BILL - TO **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.BILL_TO);
5868: --dbms_output.put_line ('*** GLOBAL VARIABLE - SHIP - TO **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.SHIP_TO);
5869: --dbms_output.put_line ('*** GLOBAL VARIABLE - PAYMENT ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.PAYMENT_TERM_ID);
5870: --dbms_output.put_line ('*** GLOBAL VARIABLE - BREAK UOM **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.BREAK_UOM);
5871:
5864: --dbms_output.put_line ('*** GLOBAL VARIABLE - PARTY - ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.PARTY_ID);
5865: --dbms_output.put_line ('*** GLOBAL VARIABLE - CUST - ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.CUSTOMER_ID);
5866: --dbms_output.put_line ('*** GLOBAL VARIABLE - BREAK UOM **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.BREAK_UOM);
5867: --dbms_output.put_line ('*** GLOBAL VARIABLE - BILL - TO **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.BILL_TO);
5868: --dbms_output.put_line ('*** GLOBAL VARIABLE - SHIP - TO **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.SHIP_TO);
5869: --dbms_output.put_line ('*** GLOBAL VARIABLE - PAYMENT ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.PAYMENT_TERM_ID);
5870: --dbms_output.put_line ('*** GLOBAL VARIABLE - BREAK UOM **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.BREAK_UOM);
5871:
5872: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5865: --dbms_output.put_line ('*** GLOBAL VARIABLE - CUST - ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.CUSTOMER_ID);
5866: --dbms_output.put_line ('*** GLOBAL VARIABLE - BREAK UOM **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.BREAK_UOM);
5867: --dbms_output.put_line ('*** GLOBAL VARIABLE - BILL - TO **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.BILL_TO);
5868: --dbms_output.put_line ('*** GLOBAL VARIABLE - SHIP - TO **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.SHIP_TO);
5869: --dbms_output.put_line ('*** GLOBAL VARIABLE - PAYMENT ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.PAYMENT_TERM_ID);
5870: --dbms_output.put_line ('*** GLOBAL VARIABLE - BREAK UOM **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.BREAK_UOM);
5871:
5872: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5873: fnd_log.STRING (fnd_log.level_statement,g_module ||l_api_name,
5866: --dbms_output.put_line ('*** GLOBAL VARIABLE - BREAK UOM **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.BREAK_UOM);
5867: --dbms_output.put_line ('*** GLOBAL VARIABLE - BILL - TO **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.BILL_TO);
5868: --dbms_output.put_line ('*** GLOBAL VARIABLE - SHIP - TO **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.SHIP_TO);
5869: --dbms_output.put_line ('*** GLOBAL VARIABLE - PAYMENT ID **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.PAYMENT_TERM_ID);
5870: --dbms_output.put_line ('*** GLOBAL VARIABLE - BREAK UOM **** ' || OKS_QPATTRIB_PVT.G_CONTRACT_LINREC.BREAK_UOM);
5871:
5872: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5873: fnd_log.STRING (fnd_log.level_statement,g_module ||l_api_name,
5874: '2029:*** Calling qp_attr_mapping_pub.build_contexts **** '