eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSP_RESOURCE_PVT dependencies on DBMS_SQL

Line 761: dbms_sql.define_column(p_cur_get_CSP, 1, P_CSP_Rec.CSP_INV_LOC_ASSIGNMENT_ID);

757: -- Debug Message
758: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Define Columns Begins');
759:
760: -- define all columns for CSP_INV_LOC_ASSIGNMENTS_V view
761: dbms_sql.define_column(p_cur_get_CSP, 1, P_CSP_Rec.CSP_INV_LOC_ASSIGNMENT_ID);
762: dbms_sql.define_column(p_cur_get_CSP, 2, P_CSP_Rec.RESOURCE_ID);
763: dbms_sql.define_column(p_cur_get_CSP, 3, P_CSP_Rec.ORGANIZATION_ID);
764: dbms_sql.define_column(p_cur_get_CSP, 4, P_CSP_Rec.SUBINVENTORY_CODE, 20);
765: dbms_sql.define_column(p_cur_get_CSP, 5, P_CSP_Rec.LOCATOR_ID);

Line 762: dbms_sql.define_column(p_cur_get_CSP, 2, P_CSP_Rec.RESOURCE_ID);

758: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Define Columns Begins');
759:
760: -- define all columns for CSP_INV_LOC_ASSIGNMENTS_V view
761: dbms_sql.define_column(p_cur_get_CSP, 1, P_CSP_Rec.CSP_INV_LOC_ASSIGNMENT_ID);
762: dbms_sql.define_column(p_cur_get_CSP, 2, P_CSP_Rec.RESOURCE_ID);
763: dbms_sql.define_column(p_cur_get_CSP, 3, P_CSP_Rec.ORGANIZATION_ID);
764: dbms_sql.define_column(p_cur_get_CSP, 4, P_CSP_Rec.SUBINVENTORY_CODE, 20);
765: dbms_sql.define_column(p_cur_get_CSP, 5, P_CSP_Rec.LOCATOR_ID);
766: dbms_sql.define_column(p_cur_get_CSP, 6, P_CSP_Rec.RESOURCE_TYPE, 30);

Line 763: dbms_sql.define_column(p_cur_get_CSP, 3, P_CSP_Rec.ORGANIZATION_ID);

759:
760: -- define all columns for CSP_INV_LOC_ASSIGNMENTS_V view
761: dbms_sql.define_column(p_cur_get_CSP, 1, P_CSP_Rec.CSP_INV_LOC_ASSIGNMENT_ID);
762: dbms_sql.define_column(p_cur_get_CSP, 2, P_CSP_Rec.RESOURCE_ID);
763: dbms_sql.define_column(p_cur_get_CSP, 3, P_CSP_Rec.ORGANIZATION_ID);
764: dbms_sql.define_column(p_cur_get_CSP, 4, P_CSP_Rec.SUBINVENTORY_CODE, 20);
765: dbms_sql.define_column(p_cur_get_CSP, 5, P_CSP_Rec.LOCATOR_ID);
766: dbms_sql.define_column(p_cur_get_CSP, 6, P_CSP_Rec.RESOURCE_TYPE, 30);
767: dbms_sql.define_column(p_cur_get_CSP, 7, P_CSP_Rec.EFFECTIVE_DATE_START);

Line 764: dbms_sql.define_column(p_cur_get_CSP, 4, P_CSP_Rec.SUBINVENTORY_CODE, 20);

760: -- define all columns for CSP_INV_LOC_ASSIGNMENTS_V view
761: dbms_sql.define_column(p_cur_get_CSP, 1, P_CSP_Rec.CSP_INV_LOC_ASSIGNMENT_ID);
762: dbms_sql.define_column(p_cur_get_CSP, 2, P_CSP_Rec.RESOURCE_ID);
763: dbms_sql.define_column(p_cur_get_CSP, 3, P_CSP_Rec.ORGANIZATION_ID);
764: dbms_sql.define_column(p_cur_get_CSP, 4, P_CSP_Rec.SUBINVENTORY_CODE, 20);
765: dbms_sql.define_column(p_cur_get_CSP, 5, P_CSP_Rec.LOCATOR_ID);
766: dbms_sql.define_column(p_cur_get_CSP, 6, P_CSP_Rec.RESOURCE_TYPE, 30);
767: dbms_sql.define_column(p_cur_get_CSP, 7, P_CSP_Rec.EFFECTIVE_DATE_START);
768: dbms_sql.define_column(p_cur_get_CSP, 8, P_CSP_Rec.EFFECTIVE_DATE_END);

Line 765: dbms_sql.define_column(p_cur_get_CSP, 5, P_CSP_Rec.LOCATOR_ID);

761: dbms_sql.define_column(p_cur_get_CSP, 1, P_CSP_Rec.CSP_INV_LOC_ASSIGNMENT_ID);
762: dbms_sql.define_column(p_cur_get_CSP, 2, P_CSP_Rec.RESOURCE_ID);
763: dbms_sql.define_column(p_cur_get_CSP, 3, P_CSP_Rec.ORGANIZATION_ID);
764: dbms_sql.define_column(p_cur_get_CSP, 4, P_CSP_Rec.SUBINVENTORY_CODE, 20);
765: dbms_sql.define_column(p_cur_get_CSP, 5, P_CSP_Rec.LOCATOR_ID);
766: dbms_sql.define_column(p_cur_get_CSP, 6, P_CSP_Rec.RESOURCE_TYPE, 30);
767: dbms_sql.define_column(p_cur_get_CSP, 7, P_CSP_Rec.EFFECTIVE_DATE_START);
768: dbms_sql.define_column(p_cur_get_CSP, 8, P_CSP_Rec.EFFECTIVE_DATE_END);
769: dbms_sql.define_column(p_cur_get_CSP, 9, P_CSP_Rec.DEFAULT_CODE, 30);

Line 766: dbms_sql.define_column(p_cur_get_CSP, 6, P_CSP_Rec.RESOURCE_TYPE, 30);

762: dbms_sql.define_column(p_cur_get_CSP, 2, P_CSP_Rec.RESOURCE_ID);
763: dbms_sql.define_column(p_cur_get_CSP, 3, P_CSP_Rec.ORGANIZATION_ID);
764: dbms_sql.define_column(p_cur_get_CSP, 4, P_CSP_Rec.SUBINVENTORY_CODE, 20);
765: dbms_sql.define_column(p_cur_get_CSP, 5, P_CSP_Rec.LOCATOR_ID);
766: dbms_sql.define_column(p_cur_get_CSP, 6, P_CSP_Rec.RESOURCE_TYPE, 30);
767: dbms_sql.define_column(p_cur_get_CSP, 7, P_CSP_Rec.EFFECTIVE_DATE_START);
768: dbms_sql.define_column(p_cur_get_CSP, 8, P_CSP_Rec.EFFECTIVE_DATE_END);
769: dbms_sql.define_column(p_cur_get_CSP, 9, P_CSP_Rec.DEFAULT_CODE, 30);
770:

Line 767: dbms_sql.define_column(p_cur_get_CSP, 7, P_CSP_Rec.EFFECTIVE_DATE_START);

763: dbms_sql.define_column(p_cur_get_CSP, 3, P_CSP_Rec.ORGANIZATION_ID);
764: dbms_sql.define_column(p_cur_get_CSP, 4, P_CSP_Rec.SUBINVENTORY_CODE, 20);
765: dbms_sql.define_column(p_cur_get_CSP, 5, P_CSP_Rec.LOCATOR_ID);
766: dbms_sql.define_column(p_cur_get_CSP, 6, P_CSP_Rec.RESOURCE_TYPE, 30);
767: dbms_sql.define_column(p_cur_get_CSP, 7, P_CSP_Rec.EFFECTIVE_DATE_START);
768: dbms_sql.define_column(p_cur_get_CSP, 8, P_CSP_Rec.EFFECTIVE_DATE_END);
769: dbms_sql.define_column(p_cur_get_CSP, 9, P_CSP_Rec.DEFAULT_CODE, 30);
770:
771: -- Debug Message

Line 768: dbms_sql.define_column(p_cur_get_CSP, 8, P_CSP_Rec.EFFECTIVE_DATE_END);

764: dbms_sql.define_column(p_cur_get_CSP, 4, P_CSP_Rec.SUBINVENTORY_CODE, 20);
765: dbms_sql.define_column(p_cur_get_CSP, 5, P_CSP_Rec.LOCATOR_ID);
766: dbms_sql.define_column(p_cur_get_CSP, 6, P_CSP_Rec.RESOURCE_TYPE, 30);
767: dbms_sql.define_column(p_cur_get_CSP, 7, P_CSP_Rec.EFFECTIVE_DATE_START);
768: dbms_sql.define_column(p_cur_get_CSP, 8, P_CSP_Rec.EFFECTIVE_DATE_END);
769: dbms_sql.define_column(p_cur_get_CSP, 9, P_CSP_Rec.DEFAULT_CODE, 30);
770:
771: -- Debug Message
772: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Define Columns Ends');

Line 769: dbms_sql.define_column(p_cur_get_CSP, 9, P_CSP_Rec.DEFAULT_CODE, 30);

765: dbms_sql.define_column(p_cur_get_CSP, 5, P_CSP_Rec.LOCATOR_ID);
766: dbms_sql.define_column(p_cur_get_CSP, 6, P_CSP_Rec.RESOURCE_TYPE, 30);
767: dbms_sql.define_column(p_cur_get_CSP, 7, P_CSP_Rec.EFFECTIVE_DATE_START);
768: dbms_sql.define_column(p_cur_get_CSP, 8, P_CSP_Rec.EFFECTIVE_DATE_END);
769: dbms_sql.define_column(p_cur_get_CSP, 9, P_CSP_Rec.DEFAULT_CODE, 30);
770:
771: -- Debug Message
772: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Define Columns Ends');
773: END Define_Columns;

Line 786: dbms_sql.column_value(p_cur_get_CSP, 1, X_CSP_Rec.CSP_INV_LOC_ASSIGNMENT_ID);

782: -- Debug Message
783: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Begins');
784:
785: -- get all column values for CSP_INV_LOC_ASSIGNMENTS_V table
786: dbms_sql.column_value(p_cur_get_CSP, 1, X_CSP_Rec.CSP_INV_LOC_ASSIGNMENT_ID);
787: dbms_sql.column_value(p_cur_get_CSP, 2, X_CSP_Rec.RESOURCE_ID);
788: dbms_sql.column_value(p_cur_get_CSP, 3, X_CSP_Rec.ORGANIZATION_ID);
789: dbms_sql.column_value(p_cur_get_CSP, 4, X_CSP_Rec.SUBINVENTORY_CODE);
790: dbms_sql.column_value(p_cur_get_CSP, 5, X_CSP_Rec.LOCATOR_ID);

Line 787: dbms_sql.column_value(p_cur_get_CSP, 2, X_CSP_Rec.RESOURCE_ID);

783: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Begins');
784:
785: -- get all column values for CSP_INV_LOC_ASSIGNMENTS_V table
786: dbms_sql.column_value(p_cur_get_CSP, 1, X_CSP_Rec.CSP_INV_LOC_ASSIGNMENT_ID);
787: dbms_sql.column_value(p_cur_get_CSP, 2, X_CSP_Rec.RESOURCE_ID);
788: dbms_sql.column_value(p_cur_get_CSP, 3, X_CSP_Rec.ORGANIZATION_ID);
789: dbms_sql.column_value(p_cur_get_CSP, 4, X_CSP_Rec.SUBINVENTORY_CODE);
790: dbms_sql.column_value(p_cur_get_CSP, 5, X_CSP_Rec.LOCATOR_ID);
791: dbms_sql.column_value(p_cur_get_CSP, 6, X_CSP_Rec.RESOURCE_TYPE);

Line 788: dbms_sql.column_value(p_cur_get_CSP, 3, X_CSP_Rec.ORGANIZATION_ID);

784:
785: -- get all column values for CSP_INV_LOC_ASSIGNMENTS_V table
786: dbms_sql.column_value(p_cur_get_CSP, 1, X_CSP_Rec.CSP_INV_LOC_ASSIGNMENT_ID);
787: dbms_sql.column_value(p_cur_get_CSP, 2, X_CSP_Rec.RESOURCE_ID);
788: dbms_sql.column_value(p_cur_get_CSP, 3, X_CSP_Rec.ORGANIZATION_ID);
789: dbms_sql.column_value(p_cur_get_CSP, 4, X_CSP_Rec.SUBINVENTORY_CODE);
790: dbms_sql.column_value(p_cur_get_CSP, 5, X_CSP_Rec.LOCATOR_ID);
791: dbms_sql.column_value(p_cur_get_CSP, 6, X_CSP_Rec.RESOURCE_TYPE);
792: dbms_sql.column_value(p_cur_get_CSP, 7, X_CSP_Rec.EFFECTIVE_DATE_START);

Line 789: dbms_sql.column_value(p_cur_get_CSP, 4, X_CSP_Rec.SUBINVENTORY_CODE);

785: -- get all column values for CSP_INV_LOC_ASSIGNMENTS_V table
786: dbms_sql.column_value(p_cur_get_CSP, 1, X_CSP_Rec.CSP_INV_LOC_ASSIGNMENT_ID);
787: dbms_sql.column_value(p_cur_get_CSP, 2, X_CSP_Rec.RESOURCE_ID);
788: dbms_sql.column_value(p_cur_get_CSP, 3, X_CSP_Rec.ORGANIZATION_ID);
789: dbms_sql.column_value(p_cur_get_CSP, 4, X_CSP_Rec.SUBINVENTORY_CODE);
790: dbms_sql.column_value(p_cur_get_CSP, 5, X_CSP_Rec.LOCATOR_ID);
791: dbms_sql.column_value(p_cur_get_CSP, 6, X_CSP_Rec.RESOURCE_TYPE);
792: dbms_sql.column_value(p_cur_get_CSP, 7, X_CSP_Rec.EFFECTIVE_DATE_START);
793: dbms_sql.column_value(p_cur_get_CSP, 8, X_CSP_Rec.EFFECTIVE_DATE_END);

Line 790: dbms_sql.column_value(p_cur_get_CSP, 5, X_CSP_Rec.LOCATOR_ID);

786: dbms_sql.column_value(p_cur_get_CSP, 1, X_CSP_Rec.CSP_INV_LOC_ASSIGNMENT_ID);
787: dbms_sql.column_value(p_cur_get_CSP, 2, X_CSP_Rec.RESOURCE_ID);
788: dbms_sql.column_value(p_cur_get_CSP, 3, X_CSP_Rec.ORGANIZATION_ID);
789: dbms_sql.column_value(p_cur_get_CSP, 4, X_CSP_Rec.SUBINVENTORY_CODE);
790: dbms_sql.column_value(p_cur_get_CSP, 5, X_CSP_Rec.LOCATOR_ID);
791: dbms_sql.column_value(p_cur_get_CSP, 6, X_CSP_Rec.RESOURCE_TYPE);
792: dbms_sql.column_value(p_cur_get_CSP, 7, X_CSP_Rec.EFFECTIVE_DATE_START);
793: dbms_sql.column_value(p_cur_get_CSP, 8, X_CSP_Rec.EFFECTIVE_DATE_END);
794: dbms_sql.column_value(p_cur_get_CSP, 9, X_CSP_Rec.DEFAULT_CODE);

Line 791: dbms_sql.column_value(p_cur_get_CSP, 6, X_CSP_Rec.RESOURCE_TYPE);

787: dbms_sql.column_value(p_cur_get_CSP, 2, X_CSP_Rec.RESOURCE_ID);
788: dbms_sql.column_value(p_cur_get_CSP, 3, X_CSP_Rec.ORGANIZATION_ID);
789: dbms_sql.column_value(p_cur_get_CSP, 4, X_CSP_Rec.SUBINVENTORY_CODE);
790: dbms_sql.column_value(p_cur_get_CSP, 5, X_CSP_Rec.LOCATOR_ID);
791: dbms_sql.column_value(p_cur_get_CSP, 6, X_CSP_Rec.RESOURCE_TYPE);
792: dbms_sql.column_value(p_cur_get_CSP, 7, X_CSP_Rec.EFFECTIVE_DATE_START);
793: dbms_sql.column_value(p_cur_get_CSP, 8, X_CSP_Rec.EFFECTIVE_DATE_END);
794: dbms_sql.column_value(p_cur_get_CSP, 9, X_CSP_Rec.DEFAULT_CODE);
795:

Line 792: dbms_sql.column_value(p_cur_get_CSP, 7, X_CSP_Rec.EFFECTIVE_DATE_START);

788: dbms_sql.column_value(p_cur_get_CSP, 3, X_CSP_Rec.ORGANIZATION_ID);
789: dbms_sql.column_value(p_cur_get_CSP, 4, X_CSP_Rec.SUBINVENTORY_CODE);
790: dbms_sql.column_value(p_cur_get_CSP, 5, X_CSP_Rec.LOCATOR_ID);
791: dbms_sql.column_value(p_cur_get_CSP, 6, X_CSP_Rec.RESOURCE_TYPE);
792: dbms_sql.column_value(p_cur_get_CSP, 7, X_CSP_Rec.EFFECTIVE_DATE_START);
793: dbms_sql.column_value(p_cur_get_CSP, 8, X_CSP_Rec.EFFECTIVE_DATE_END);
794: dbms_sql.column_value(p_cur_get_CSP, 9, X_CSP_Rec.DEFAULT_CODE);
795:
796: -- Debug Message

Line 793: dbms_sql.column_value(p_cur_get_CSP, 8, X_CSP_Rec.EFFECTIVE_DATE_END);

789: dbms_sql.column_value(p_cur_get_CSP, 4, X_CSP_Rec.SUBINVENTORY_CODE);
790: dbms_sql.column_value(p_cur_get_CSP, 5, X_CSP_Rec.LOCATOR_ID);
791: dbms_sql.column_value(p_cur_get_CSP, 6, X_CSP_Rec.RESOURCE_TYPE);
792: dbms_sql.column_value(p_cur_get_CSP, 7, X_CSP_Rec.EFFECTIVE_DATE_START);
793: dbms_sql.column_value(p_cur_get_CSP, 8, X_CSP_Rec.EFFECTIVE_DATE_END);
794: dbms_sql.column_value(p_cur_get_CSP, 9, X_CSP_Rec.DEFAULT_CODE);
795:
796: -- Debug Message
797: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Ends');

Line 794: dbms_sql.column_value(p_cur_get_CSP, 9, X_CSP_Rec.DEFAULT_CODE);

790: dbms_sql.column_value(p_cur_get_CSP, 5, X_CSP_Rec.LOCATOR_ID);
791: dbms_sql.column_value(p_cur_get_CSP, 6, X_CSP_Rec.RESOURCE_TYPE);
792: dbms_sql.column_value(p_cur_get_CSP, 7, X_CSP_Rec.EFFECTIVE_DATE_START);
793: dbms_sql.column_value(p_cur_get_CSP, 8, X_CSP_Rec.EFFECTIVE_DATE_END);
794: dbms_sql.column_value(p_cur_get_CSP, 9, X_CSP_Rec.DEFAULT_CODE);
795:
796: -- Debug Message
797: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Ends');
798: END Get_Column_Values;

Line 860: DBMS_SQL.BIND_VARIABLE(p_cur_get_CSP, ':p_CSP_INV_LOC_ASSIGNMENT_ID', P_CSP_Rec.CSP_INV_LOC_ASSIGNMENT_ID);

856: -- The following example applies to all columns,
857: -- developers can copy and paste them.
858: IF( (P_CSP_Rec.CSP_INV_LOC_ASSIGNMENT_ID IS NOT NULL) AND (P_CSP_Rec.CSP_INV_LOC_ASSIGNMENT_ID <> FND_API.G_MISS_NUM) )
859: THEN
860: DBMS_SQL.BIND_VARIABLE(p_cur_get_CSP, ':p_CSP_INV_LOC_ASSIGNMENT_ID', P_CSP_Rec.CSP_INV_LOC_ASSIGNMENT_ID);
861: END IF;
862:
863: -- Debug Message
864: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Bind Variables Ends');