DBA Data[Home] [Help]

APPS.OKL_SSC_WF dependencies on CSI_DATASTRUCTURES_PUB

Line 1001: x_trx_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.transaction_rec) IS

997: x_msg_count OUT NOCOPY NUMBER,
998: x_msg_data OUT NOCOPY VARCHAR2,
999: p_cle_id IN NUMBER,
1000: p_transaction_type IN VARCHAR2,
1001: x_trx_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.transaction_rec) IS
1002:
1003: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1004: l_api_name CONSTANT VARCHAR2(30) := 'GET_TRX_REC';
1005: l_api_version CONSTANT NUMBER := 1.0;

Line 1093: SUBTYPE instance_rec IS CSI_DATASTRUCTURES_PUB.instance_rec;

1089: l_tas_id NUMBER;
1090: l_kle_id NUMBER;
1091: l_object_version_number NUMBER;
1092:
1093: SUBTYPE instance_rec IS CSI_DATASTRUCTURES_PUB.instance_rec;
1094: SUBTYPE extend_attrib_values_tbl IS CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
1095: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1096: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1097: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;

Line 1094: SUBTYPE extend_attrib_values_tbl IS CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;

1090: l_kle_id NUMBER;
1091: l_object_version_number NUMBER;
1092:
1093: SUBTYPE instance_rec IS CSI_DATASTRUCTURES_PUB.instance_rec;
1094: SUBTYPE extend_attrib_values_tbl IS CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
1095: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1096: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1097: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1098: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;

Line 1095: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;

1091: l_object_version_number NUMBER;
1092:
1093: SUBTYPE instance_rec IS CSI_DATASTRUCTURES_PUB.instance_rec;
1094: SUBTYPE extend_attrib_values_tbl IS CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
1095: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1096: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1097: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1098: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1099: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;

Line 1096: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;

1092:
1093: SUBTYPE instance_rec IS CSI_DATASTRUCTURES_PUB.instance_rec;
1094: SUBTYPE extend_attrib_values_tbl IS CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
1095: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1096: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1097: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1098: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1099: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
1100: SUBTYPE transaction_rec IS CSI_DATASTRUCTURES_PUB.transaction_rec;

Line 1097: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;

1093: SUBTYPE instance_rec IS CSI_DATASTRUCTURES_PUB.instance_rec;
1094: SUBTYPE extend_attrib_values_tbl IS CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
1095: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1096: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1097: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1098: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1099: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
1100: SUBTYPE transaction_rec IS CSI_DATASTRUCTURES_PUB.transaction_rec;
1101: SUBTYPE id_tbl IS CSI_DATASTRUCTURES_PUB.id_tbl;

Line 1098: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;

1094: SUBTYPE extend_attrib_values_tbl IS CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
1095: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1096: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1097: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1098: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1099: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
1100: SUBTYPE transaction_rec IS CSI_DATASTRUCTURES_PUB.transaction_rec;
1101: SUBTYPE id_tbl IS CSI_DATASTRUCTURES_PUB.id_tbl;
1102:

Line 1099: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;

1095: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1096: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1097: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1098: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1099: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
1100: SUBTYPE transaction_rec IS CSI_DATASTRUCTURES_PUB.transaction_rec;
1101: SUBTYPE id_tbl IS CSI_DATASTRUCTURES_PUB.id_tbl;
1102:
1103: l_instance_rec_type instance_rec;

Line 1100: SUBTYPE transaction_rec IS CSI_DATASTRUCTURES_PUB.transaction_rec;

1096: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1097: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1098: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1099: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
1100: SUBTYPE transaction_rec IS CSI_DATASTRUCTURES_PUB.transaction_rec;
1101: SUBTYPE id_tbl IS CSI_DATASTRUCTURES_PUB.id_tbl;
1102:
1103: l_instance_rec_type instance_rec;
1104: l_ext_attrib_values_tbl extend_attrib_values_tbl;

Line 1101: SUBTYPE id_tbl IS CSI_DATASTRUCTURES_PUB.id_tbl;

1097: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1098: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1099: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
1100: SUBTYPE transaction_rec IS CSI_DATASTRUCTURES_PUB.transaction_rec;
1101: SUBTYPE id_tbl IS CSI_DATASTRUCTURES_PUB.id_tbl;
1102:
1103: l_instance_rec_type instance_rec;
1104: l_ext_attrib_values_tbl extend_attrib_values_tbl;
1105: l_party_tbl party_tbl;

Line 1228: SUBTYPE instance_rec IS CSI_DATASTRUCTURES_PUB.instance_rec;

1224: WHERE KIT.CLE_ID = (SELECT KLB.ID FROM OKC_K_LINES_B KLB WHERE
1225: KLB.ID = p_kle_id);
1226:
1227:
1228: SUBTYPE instance_rec IS CSI_DATASTRUCTURES_PUB.instance_rec;
1229: SUBTYPE extend_attrib_values_tbl IS CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
1230: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1231: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1232: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;

Line 1229: SUBTYPE extend_attrib_values_tbl IS CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;

1225: KLB.ID = p_kle_id);
1226:
1227:
1228: SUBTYPE instance_rec IS CSI_DATASTRUCTURES_PUB.instance_rec;
1229: SUBTYPE extend_attrib_values_tbl IS CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
1230: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1231: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1232: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1233: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;

Line 1230: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;

1226:
1227:
1228: SUBTYPE instance_rec IS CSI_DATASTRUCTURES_PUB.instance_rec;
1229: SUBTYPE extend_attrib_values_tbl IS CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
1230: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1231: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1232: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1233: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1234: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;

Line 1231: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;

1227:
1228: SUBTYPE instance_rec IS CSI_DATASTRUCTURES_PUB.instance_rec;
1229: SUBTYPE extend_attrib_values_tbl IS CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
1230: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1231: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1232: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1233: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1234: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
1235: SUBTYPE transaction_rec IS CSI_DATASTRUCTURES_PUB.transaction_rec;

Line 1232: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;

1228: SUBTYPE instance_rec IS CSI_DATASTRUCTURES_PUB.instance_rec;
1229: SUBTYPE extend_attrib_values_tbl IS CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
1230: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1231: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1232: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1233: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1234: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
1235: SUBTYPE transaction_rec IS CSI_DATASTRUCTURES_PUB.transaction_rec;
1236: SUBTYPE id_tbl IS CSI_DATASTRUCTURES_PUB.id_tbl;

Line 1233: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;

1229: SUBTYPE extend_attrib_values_tbl IS CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
1230: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1231: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1232: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1233: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1234: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
1235: SUBTYPE transaction_rec IS CSI_DATASTRUCTURES_PUB.transaction_rec;
1236: SUBTYPE id_tbl IS CSI_DATASTRUCTURES_PUB.id_tbl;
1237:

Line 1234: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;

1230: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1231: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1232: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1233: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1234: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
1235: SUBTYPE transaction_rec IS CSI_DATASTRUCTURES_PUB.transaction_rec;
1236: SUBTYPE id_tbl IS CSI_DATASTRUCTURES_PUB.id_tbl;
1237:
1238: l_instance_rec_type instance_rec;

Line 1235: SUBTYPE transaction_rec IS CSI_DATASTRUCTURES_PUB.transaction_rec;

1231: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1232: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1233: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1234: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
1235: SUBTYPE transaction_rec IS CSI_DATASTRUCTURES_PUB.transaction_rec;
1236: SUBTYPE id_tbl IS CSI_DATASTRUCTURES_PUB.id_tbl;
1237:
1238: l_instance_rec_type instance_rec;
1239: l_ext_attrib_values_tbl extend_attrib_values_tbl;

Line 1236: SUBTYPE id_tbl IS CSI_DATASTRUCTURES_PUB.id_tbl;

1232: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1233: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1234: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
1235: SUBTYPE transaction_rec IS CSI_DATASTRUCTURES_PUB.transaction_rec;
1236: SUBTYPE id_tbl IS CSI_DATASTRUCTURES_PUB.id_tbl;
1237:
1238: l_instance_rec_type instance_rec;
1239: l_ext_attrib_values_tbl extend_attrib_values_tbl;
1240: l_party_tbl party_tbl;