4583:
4584:
4585: RETURN aPlsqlItem;
4586: END SQL_TO_PL44;
4587: FUNCTION PL_TO_SQL21(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE)
4588: RETURN OE_ORDER_PUB_LINE_PAYMENT_TBL IS
4589: aSqlItem OE_ORDER_PUB_LINE_PAYMENT_TBL;
4590: BEGIN
4591: aSqlItem := OE_ORDER_PUB_LINE_PAYMENT_TBL();
4584:
4585: RETURN aPlsqlItem;
4586: END SQL_TO_PL44;
4587: FUNCTION PL_TO_SQL21(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE)
4588: RETURN OE_ORDER_PUB_LINE_PAYMENT_TBL IS
4589: aSqlItem OE_ORDER_PUB_LINE_PAYMENT_TBL;
4590: BEGIN
4591: aSqlItem := OE_ORDER_PUB_LINE_PAYMENT_TBL();
4592: IF aPlsqlItem.COUNT > 0 THEN
4585: RETURN aPlsqlItem;
4586: END SQL_TO_PL44;
4587: FUNCTION PL_TO_SQL21(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE)
4588: RETURN OE_ORDER_PUB_LINE_PAYMENT_TBL IS
4589: aSqlItem OE_ORDER_PUB_LINE_PAYMENT_TBL;
4590: BEGIN
4591: aSqlItem := OE_ORDER_PUB_LINE_PAYMENT_TBL();
4592: IF aPlsqlItem.COUNT > 0 THEN
4593: aSqlItem.EXTEND(aPlsqlItem.COUNT);
4587: FUNCTION PL_TO_SQL21(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE)
4588: RETURN OE_ORDER_PUB_LINE_PAYMENT_TBL IS
4589: aSqlItem OE_ORDER_PUB_LINE_PAYMENT_TBL;
4590: BEGIN
4591: aSqlItem := OE_ORDER_PUB_LINE_PAYMENT_TBL();
4592: IF aPlsqlItem.COUNT > 0 THEN
4593: aSqlItem.EXTEND(aPlsqlItem.COUNT);
4594: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
4595: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL44(aPlsqlItem(I));
4596: END LOOP;
4597: END IF;
4598: RETURN aSqlItem;
4599: END PL_TO_SQL21;
4600: FUNCTION SQL_TO_PL21(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_TBL)
4601: RETURN OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE IS
4602: aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE;
4603: BEGIN
4604: BEGIN
4597: END IF;
4598: RETURN aSqlItem;
4599: END PL_TO_SQL21;
4600: FUNCTION SQL_TO_PL21(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_TBL)
4601: RETURN OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE IS
4602: aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE;
4603: BEGIN
4604: BEGIN
4605: FOR I IN 1..aSqlItem.COUNT LOOP
4598: RETURN aSqlItem;
4599: END PL_TO_SQL21;
4600: FUNCTION SQL_TO_PL21(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_TBL)
4601: RETURN OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE IS
4602: aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE;
4603: BEGIN
4604: BEGIN
4605: FOR I IN 1..aSqlItem.COUNT LOOP
4606: aPlsqlItem(I) := SQL_TO_PL44(aSqlItem(I));
5025: P_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
5026: P_OLD_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
5027: P_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
5028: P_OLD_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
5029: P_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
5030: P_OLD_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
5031: P_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
5032: P_OLD_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
5033: P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
5026: P_OLD_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
5027: P_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
5028: P_OLD_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
5029: P_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
5030: P_OLD_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
5031: P_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
5032: P_OLD_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
5033: P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
5034: P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
5054: X_LINE_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
5055: X_LINE_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
5056: X_LINE_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_TBL,
5057: X_LINE_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_VAL,
5058: X_LINE_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_TBL,
5059: X_LINE_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_VAL,
5060: X_LOT_SERIAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_TBL_T,
5061: X_LOT_SERIAL_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_VAL_T ,
5062: X_ACTION_REQUEST_TBL OUT NOCOPY OE_ORDER_PUB_REQUEST_TBL_TYPE,
5811: P_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
5812: P_OLD_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
5813: P_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
5814: P_OLD_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
5815: P_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
5816: P_OLD_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
5817: P_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
5818: P_OLD_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
5819: P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
5812: P_OLD_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
5813: P_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
5814: P_OLD_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
5815: P_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
5816: P_OLD_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
5817: P_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
5818: P_OLD_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
5819: P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
5820: P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
5840: X_LINE_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ATT_TBL ,
5841: X_LINE_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ASSOC_T ,
5842: X_LINE_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_TBL ,
5843: X_LINE_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_VAL ,
5844: X_LINE_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_TBL ,
5845: X_LINE_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_VAL ,
5846: X_LOT_SERIAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_TBL_T ,
5847: X_LOT_SERIAL_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_VAL_T ,
5848: X_ACTION_REQUEST_TBL OUT NOCOPY OE_ORDER_PUB_REQUEST_TBL_TYPE ,
5888: P_LINE_SCREDIT_TBL_ OE_ORDER_PUB.LINE_SCREDIT_TBL_TYPE;
5889: P_OLD_LINE_SCREDIT_TBL_ OE_ORDER_PUB.LINE_SCREDIT_TBL_TYPE;
5890: P_LINE_SCREDIT_VAL_TBL_ OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE;
5891: P_OLD_LINE_SCREDIT_VAL_TBL_ OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE;
5892: P_LINE_PAYMENT_TBL_ OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE;
5893: P_OLD_LINE_PAYMENT_TBL_ OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE;
5894: P_LINE_PAYMENT_VAL_TBL_ OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE;
5895: P_OLD_LINE_PAYMENT_VAL_TBL_ OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE;
5896: P_LOT_SERIAL_TBL_ OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE;
5889: P_OLD_LINE_SCREDIT_TBL_ OE_ORDER_PUB.LINE_SCREDIT_TBL_TYPE;
5890: P_LINE_SCREDIT_VAL_TBL_ OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE;
5891: P_OLD_LINE_SCREDIT_VAL_TBL_ OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE;
5892: P_LINE_PAYMENT_TBL_ OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE;
5893: P_OLD_LINE_PAYMENT_TBL_ OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE;
5894: P_LINE_PAYMENT_VAL_TBL_ OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE;
5895: P_OLD_LINE_PAYMENT_VAL_TBL_ OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE;
5896: P_LOT_SERIAL_TBL_ OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE;
5897: P_OLD_LOT_SERIAL_TBL_ OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE;
5917: X_LINE_ADJ_ATT_TBL_ OE_ORDER_PUB.LINE_ADJ_ATT_TBL_TYPE;
5918: X_LINE_ADJ_ASSOC_TBL_ OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE;
5919: X_LINE_SCREDIT_TBL_ OE_ORDER_PUB.LINE_SCREDIT_TBL_TYPE;
5920: X_LINE_SCREDIT_VAL_TBL_ OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE;
5921: X_LINE_PAYMENT_TBL_ OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE;
5922: X_LINE_PAYMENT_VAL_TBL_ OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE;
5923: X_LOT_SERIAL_TBL_ OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE;
5924: X_LOT_SERIAL_VAL_TBL_ OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE;
5925: X_ACTION_REQUEST_TBL_ OE_ORDER_PUB.REQUEST_TBL_TYPE;
6431: P_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
6432: P_OLD_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
6433: P_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
6434: P_OLD_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
6435: P_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
6436: P_OLD_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
6437: P_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
6438: P_OLD_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
6439: P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
6432: P_OLD_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
6433: P_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
6434: P_OLD_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
6435: P_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
6436: P_OLD_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
6437: P_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
6438: P_OLD_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
6439: P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
6440: P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
6460: X_LINE_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ATT_TBL ,
6461: X_LINE_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ASSOC_T ,
6462: X_LINE_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_TBL ,
6463: X_LINE_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_VAL ,
6464: X_LINE_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_TBL ,
6465: X_LINE_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_VAL ,
6466: X_LOT_SERIAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_TBL_T ,
6467: X_LOT_SERIAL_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_VAL_T ,
6468: X_ACTION_REQUEST_TBL OUT NOCOPY OE_ORDER_PUB_REQUEST_TBL_TYPE ,