DBA Data[Home] [Help]

APPS.OKL_AM_SERVICE_K_INT_WF dependencies on WF_ITEMS

Line 678: l_key WF_ITEMS.item_key%TYPE;

674: p_transaction_date IN DATE) IS
675:
676:
677: l_parameter_list WF_PARAMETER_LIST_T;
678: l_key WF_ITEMS.item_key%TYPE;
679: l_event_name WF_EVENTS.NAME%TYPE := 'oracle.apps.okl.am.servicekintegration';
680: l_seq NUMBER;
681:
682: -- Cursor to get the value of the sequence

Line 1123: l_item_type WF_ITEMS.item_type%TYPE;

1119: display_type IN VARCHAR2,
1120: document IN OUT NOCOPY VARCHAR2,
1121: document_type IN OUT NOCOPY VARCHAR2) IS
1122:
1123: l_item_type WF_ITEMS.item_type%TYPE;
1124: l_item_key WF_ITEMS.item_key%TYPE;
1125: l_colon NUMBER;
1126: l_msgbody VARCHAR2(32000);
1127: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;

Line 1124: l_item_key WF_ITEMS.item_key%TYPE;

1120: document IN OUT NOCOPY VARCHAR2,
1121: document_type IN OUT NOCOPY VARCHAR2) IS
1122:
1123: l_item_type WF_ITEMS.item_type%TYPE;
1124: l_item_key WF_ITEMS.item_key%TYPE;
1125: l_colon NUMBER;
1126: l_msgbody VARCHAR2(32000);
1127: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1128: l_oks_contract_number OKC_K_HEADERS_B.contract_number%TYPE;

Line 1343: l_item_type WF_ITEMS.item_type%TYPE;

1339: display_type IN VARCHAR2,
1340: document IN OUT NOCOPY VARCHAR2,
1341: document_type IN OUT NOCOPY VARCHAR2) IS
1342:
1343: l_item_type WF_ITEMS.item_type%TYPE;
1344: l_item_key WF_ITEMS.item_key%TYPE;
1345: l_colon NUMBER;
1346: l_msgbody VARCHAR2(32000);
1347: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;

Line 1344: l_item_key WF_ITEMS.item_key%TYPE;

1340: document IN OUT NOCOPY VARCHAR2,
1341: document_type IN OUT NOCOPY VARCHAR2) IS
1342:
1343: l_item_type WF_ITEMS.item_type%TYPE;
1344: l_item_key WF_ITEMS.item_key%TYPE;
1345: l_colon NUMBER;
1346: l_msgbody VARCHAR2(32000);
1347: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1348: l_oks_contract_number OKC_K_HEADERS_B.contract_number%TYPE;

Line 1543: l_item_type WF_ITEMS.item_type%TYPE;

1539: display_type IN VARCHAR2,
1540: document IN OUT NOCOPY VARCHAR2,
1541: document_type IN OUT NOCOPY VARCHAR2) IS
1542:
1543: l_item_type WF_ITEMS.item_type%TYPE;
1544: l_item_key WF_ITEMS.item_key%TYPE;
1545: l_colon NUMBER;
1546: l_msgbody VARCHAR2(32000);
1547: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;

Line 1544: l_item_key WF_ITEMS.item_key%TYPE;

1540: document IN OUT NOCOPY VARCHAR2,
1541: document_type IN OUT NOCOPY VARCHAR2) IS
1542:
1543: l_item_type WF_ITEMS.item_type%TYPE;
1544: l_item_key WF_ITEMS.item_key%TYPE;
1545: l_colon NUMBER;
1546: l_msgbody VARCHAR2(32000);
1547: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1548: l_oks_contract_number OKC_K_HEADERS_B.contract_number%TYPE;

Line 1756: l_item_type WF_ITEMS.item_type%TYPE;

1752: display_type IN VARCHAR2,
1753: document IN OUT NOCOPY VARCHAR2,
1754: document_type IN OUT NOCOPY VARCHAR2) IS
1755:
1756: l_item_type WF_ITEMS.item_type%TYPE;
1757: l_item_key WF_ITEMS.item_key%TYPE;
1758: l_colon NUMBER;
1759: l_msgbody VARCHAR2(32000);
1760: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;

Line 1757: l_item_key WF_ITEMS.item_key%TYPE;

1753: document IN OUT NOCOPY VARCHAR2,
1754: document_type IN OUT NOCOPY VARCHAR2) IS
1755:
1756: l_item_type WF_ITEMS.item_type%TYPE;
1757: l_item_key WF_ITEMS.item_key%TYPE;
1758: l_colon NUMBER;
1759: l_msgbody VARCHAR2(32000);
1760: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1761: l_oks_contract_number OKC_K_HEADERS_B.contract_number%TYPE;

Line 1944: l_item_type WF_ITEMS.item_type%TYPE;

1940: display_type IN VARCHAR2,
1941: document IN OUT NOCOPY VARCHAR2,
1942: document_type IN OUT NOCOPY VARCHAR2) IS
1943:
1944: l_item_type WF_ITEMS.item_type%TYPE;
1945: l_item_key WF_ITEMS.item_key%TYPE;
1946: l_colon NUMBER;
1947: l_msgbody VARCHAR2(32000);
1948: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;

Line 1945: l_item_key WF_ITEMS.item_key%TYPE;

1941: document IN OUT NOCOPY VARCHAR2,
1942: document_type IN OUT NOCOPY VARCHAR2) IS
1943:
1944: l_item_type WF_ITEMS.item_type%TYPE;
1945: l_item_key WF_ITEMS.item_key%TYPE;
1946: l_colon NUMBER;
1947: l_msgbody VARCHAR2(32000);
1948: l_okl_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
1949: l_oks_contract_number OKC_K_HEADERS_B.contract_number%TYPE;