[Home] [Help]
365: --End of Function
366: END check_account;
367:
368: /***** Private API to construct the Data to be published */
369: /* Inserts the publishing related data into the table xnb_bill_to_party_details */
370:
371:
372: PROCEDURE publish_bill_to_address( itemtype IN VARCHAR2,
373: itemkey IN VARCHAR2,
541: l_postal_code,
542: x_result);
543:
544: ----------------------------------------------------------------------------
545: --Store the complete address details and flags into xnb_bill_to_party_details
546: --
547: ----------------------------------------------------------------------------
548:
549: create_sales_order ( l_doc_id,
590: l_postal_code,
591: x_result);
592:
593: ---------------------------------------------------------------------------
594: --Store the complete address details and flags into xnb_bill_to_party_details
595: --
596: ---------------------------------------------------------------------------
597:
598: create_sales_order ( l_doc_id,
765: --End of Function
766: END get_bill_to_address;
767:
768: /***** Private API to insert the sales Order Data to be published into the table */
769: /* xnb_bill_to_party_details */
770: /* */
771:
772:
773: PROCEDURE create_sales_order
794: l_sql VARCHAR2(5000);
795:
796: BEGIN
797: -------------------------------------------------------------------------------------------
798: --Insert the records to XNB_BILL_TO_PARTY_DETAILS
799: --
800: -------------------------------------------------------------------------------------------
801:
802: l_sql := 'INSERT INTO xnb_bill_to_party_details'||
798: --Insert the records to XNB_BILL_TO_PARTY_DETAILS
799: --
800: -------------------------------------------------------------------------------------------
801:
802: l_sql := 'INSERT INTO xnb_bill_to_party_details'||
803: '(PARTY_ATTRIBUTE1, '||
804: 'PARTY_ATTRIBUTE2, '||
805: 'PARTY_ATTRIBUTE3, '||
806: 'PARTY_ATTRIBUTE4, '||
894:
895: --End of Function
896: END create_sales_order;
897:
898: /***** Private API to remove the published data from the xnb_bill_to_party_details */
899: /* */
900: /* */
901:
902: PROCEDURE truncate_sales_order (
921: --Query to Delete the Published details
922: --
923: ------------------------------------------------------------------------------
924:
925: DELETE FROM xnb_bill_to_party_details
926: WHERE order_line_id = l_doc_id;
927:
928: COMMIT;
929:
1364: l_postal_code,
1365: x_result);
1366:
1367: ----------------------------------------------------------------------------
1368: --Store the complete address details and flags into xnb_bill_to_party_details
1369: --
1370: ----------------------------------------------------------------------------
1371:
1372: create_sales_order ( l_line_id,
1414: l_postal_code,
1415: x_result);
1416:
1417: ---------------------------------------------------------------------------
1418: --Store the complete address details and flags into xnb_bill_to_party_details
1419: --
1420: ---------------------------------------------------------------------------
1421:
1422: create_sales_order ( l_line_id,
1566: OPEN l_line_ids (l_order_number);
1567: FETCH l_line_ids INTO l_line_id;
1568: WHILE (l_line_ids%FOUND) LOOP
1569:
1570: DELETE FROM xnb_bill_to_party_details
1571: WHERE order_line_id = l_line_id;
1572:
1573: FETCH l_line_ids INTO l_line_id;
1574: END LOOP;