APPS.PA_RESOURCE_PKG dependencies on PA_RESOURCE_TXN_ATTRIBUTES

Line 6: THE INSERT_ROW2 PROCEDURE INSERTS INTO PA_RESOURCE_TXN_ATTRIBUTES TABLE.

2: -- $Header: PARCTBHB.pls 120.1 2005/08/19 16:49:47 mwasowic noship $
3: AS
4:
5: /* THE INSERT_ROW1 PROCEDURE INSERTS INTO PA_RESOURCES TABLE.
6: THE INSERT_ROW2 PROCEDURE INSERTS INTO PA_RESOURCE_TXN_ATTRIBUTES TABLE.
7: THE INSERT_ROW3 PROCEDURE INSERTS INTO PA_RESOURCE_OU TABLE.*/
8:
9: PROCEDURE INSERT_ROW1(
10: X_ROWID IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 106: X_RESOURCE_TXN_ATTRIBUTE_ID IN PA_RESOURCE_TXN_ATTRIBUTES.

102:
103: --begin of Insert_row2 procedure
104: PROCEDURE INSERT_ROW2 (
105: X_ROWID IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
106: X_RESOURCE_TXN_ATTRIBUTE_ID IN PA_RESOURCE_TXN_ATTRIBUTES.
107: RESOURCE_TXN_ATTRIBUTE_ID%TYPE,
108: X_RESOURCE_ID IN PA_RESOURCE_TXN_ATTRIBUTES.
109: RESOURCE_ID%TYPE,
110: X_PERSON_ID IN PA_RESOURCE_TXN_ATTRIBUTES.

Line 108: X_RESOURCE_ID IN PA_RESOURCE_TXN_ATTRIBUTES.

104: PROCEDURE INSERT_ROW2 (
105: X_ROWID IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
106: X_RESOURCE_TXN_ATTRIBUTE_ID IN PA_RESOURCE_TXN_ATTRIBUTES.
107: RESOURCE_TXN_ATTRIBUTE_ID%TYPE,
108: X_RESOURCE_ID IN PA_RESOURCE_TXN_ATTRIBUTES.
109: RESOURCE_ID%TYPE,
110: X_PERSON_ID IN PA_RESOURCE_TXN_ATTRIBUTES.
111: PERSON_ID%TYPE,
112: X_RESOURCE_FORMAT_ID IN PA_RESOURCE_TXN_ATTRIBUTES.

Line 110: X_PERSON_ID IN PA_RESOURCE_TXN_ATTRIBUTES.

106: X_RESOURCE_TXN_ATTRIBUTE_ID IN PA_RESOURCE_TXN_ATTRIBUTES.
107: RESOURCE_TXN_ATTRIBUTE_ID%TYPE,
108: X_RESOURCE_ID IN PA_RESOURCE_TXN_ATTRIBUTES.
109: RESOURCE_ID%TYPE,
110: X_PERSON_ID IN PA_RESOURCE_TXN_ATTRIBUTES.
111: PERSON_ID%TYPE,
112: X_RESOURCE_FORMAT_ID IN PA_RESOURCE_TXN_ATTRIBUTES.
113: RESOURCE_FORMAT_ID%TYPE,
114: X_REQUEST_ID IN NUMBER,

Line 112: X_RESOURCE_FORMAT_ID IN PA_RESOURCE_TXN_ATTRIBUTES.

108: X_RESOURCE_ID IN PA_RESOURCE_TXN_ATTRIBUTES.
109: RESOURCE_ID%TYPE,
110: X_PERSON_ID IN PA_RESOURCE_TXN_ATTRIBUTES.
111: PERSON_ID%TYPE,
112: X_RESOURCE_FORMAT_ID IN PA_RESOURCE_TXN_ATTRIBUTES.
113: RESOURCE_FORMAT_ID%TYPE,
114: X_REQUEST_ID IN NUMBER,
115: X_PROGRAM_ID IN NUMBER,
116: X_PARTY_ID IN PA_RESOURCE_TXN_ATTRIBUTES.

Line 116: X_PARTY_ID IN PA_RESOURCE_TXN_ATTRIBUTES.

112: X_RESOURCE_FORMAT_ID IN PA_RESOURCE_TXN_ATTRIBUTES.
113: RESOURCE_FORMAT_ID%TYPE,
114: X_REQUEST_ID IN NUMBER,
115: X_PROGRAM_ID IN NUMBER,
116: X_PARTY_ID IN PA_RESOURCE_TXN_ATTRIBUTES.
117: PARTY_ID%TYPE,
118: X_PROGRAM_UPDATE_DATE IN DATE,
119: X_PROGRAM_APPLICATION_ID IN NUMBER,
120: X_LAST_UPDATE_BY IN NUMBER,

Line 131: select rowid from pa_resource_txn_attributes

127: l_check_dup_id VARCHAR2(1);
128: --l_resource_txn_attribute_id NUBMER;
129: --cursor to select rowid of current insert
130: cursor c is
131: select rowid from pa_resource_txn_attributes
132: where resource_txn_attribute_id = resource_txn_attribute_id;
133:
134: BEGIN
135: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 138: insert into PA_RESOURCE_TXN_ATTRIBUTES (

134: BEGIN
135: x_return_status := FND_API.G_RET_STS_SUCCESS;
136:
137: --actual insert into pa_resource_txn_attribute
138: insert into PA_RESOURCE_TXN_ATTRIBUTES (
139: resource_txn_attribute_id
140: ,resource_id
141: ,person_id
142: ,resource_format_id