3:
4: ---------------------------------------------------------------------------
5: -- GLOBAL MESSAGE CONSTANTS
6: ---------------------------------------------------------------------------
7: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
8: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
9: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
10: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME';
11: G_COL_NAME1_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME1';
5: -- GLOBAL MESSAGE CONSTANTS
6: ---------------------------------------------------------------------------
7: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
8: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
9: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
10: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME';
11: G_COL_NAME1_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME1';
12: G_COL_NAME2_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME2';
13: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := 'PARENT_TABLE';
64: PROCEDURE api_copy;
65: -- Creates internal transactions for cutomer and contract combination
66: PROCEDURE CREATE_INTERNAL_TRANS(
67: p_api_version IN NUMBER,
68: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
69: p_customer_id IN NUMBER,
70: p_contract_id IN NUMBER,
71: p_contract_num IN VARCHAR2 DEFAULT NULL,
72: p_payment_method_id IN NUMBER,
82:
83: -- Creates internal transactions for cutomer and invoice combination
84: PROCEDURE CREATE_INTERNAL_TRANS(
85: p_api_version IN NUMBER,
86: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
87: p_customer_id IN NUMBER,
88: p_invoice_id IN NUMBER,
89: p_payment_method_id IN NUMBER,
90: p_payment_ref_number IN VARCHAR2,
99:
100: -- Called from Make Payments UI
101: PROCEDURE CREATE_PAYMENTS(
102: p_api_version IN NUMBER,
103: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
104: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
105: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
106: x_return_status OUT NOCOPY VARCHAR2,
107: x_msg_count OUT NOCOPY NUMBER,