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.PSB_ACCOUNT_POSITION_SET_PVT dependencies on PSB_ACCOUNT_POSITION_SETS

Line 58: FROM psb_account_position_sets

54: l_api_version CONSTANT NUMBER := 1.0;
55: --
56: CURSOR C IS
57: SELECT rowid
58: FROM psb_account_position_sets
59: WHERE account_position_set_id = p_account_position_set_id;
60:
61: CURSOR C2 IS
62: SELECT psb_account_position_sets_s.nextval

Line 62: SELECT psb_account_position_sets_s.nextval

58: FROM psb_account_position_sets
59: WHERE account_position_set_id = p_account_position_set_id;
60:
61: CURSOR C2 IS
62: SELECT psb_account_position_sets_s.nextval
63: FROM dual;
64: BEGIN
65: --
66: SAVEPOINT Insert_Row_Pvt ;

Line 91: INSERT INTO psb_account_position_sets(

87: FETCH C2 INTO p_account_position_set_id;
88: CLOSE C2;
89: END IF;
90:
91: INSERT INTO psb_account_position_sets(
92: account_position_set_id,
93: name,
94: set_of_books_id,
95: use_in_budget_group_flag,

Line 213: FROM psb_account_position_sets

209: --
210: Counter NUMBER;
211: CURSOR C IS
212: SELECT *
213: FROM psb_account_position_sets
214: WHERE rowid = p_row_id
215: FOR UPDATE of Account_Position_Set_Id NOWAIT;
216: Recinfo C%ROWTYPE;
217:

Line 404: UPDATE psb_account_position_sets

400: --
401: p_return_status := FND_API.G_RET_STS_SUCCESS ;
402: --
403:
404: UPDATE psb_account_position_sets
405: SET
406: account_position_set_id = p_account_position_set_id,
407: name = p_name,
408: set_of_books_id = p_set_of_books_id,

Line 524: FROM psb_account_position_sets

520: -- ( To maintain ISOLATED master-detail form relation also. )
521: --
522:
523: SELECT account_position_set_id INTO l_account_position_set_id
524: FROM psb_account_position_sets
525: WHERE rowid = p_row_id ;
526:
527: --
528: -- When we delete a set line, we also need to delete all records associated

Line 560: -- Deleting the record in psb_account_position_sets.

556: --
557: END LOOP ;
558:
559: --
560: -- Deleting the record in psb_account_position_sets.
561: --
562: DELETE FROM psb_account_position_sets
563: WHERE rowid = p_row_id;
564:

Line 562: DELETE FROM psb_account_position_sets

558:
559: --
560: -- Deleting the record in psb_account_position_sets.
561: --
562: DELETE FROM psb_account_position_sets
563: WHERE rowid = p_row_id;
564:
565: IF (SQL%NOTFOUND) THEN
566: RAISE NO_DATA_FOUND ;

Line 639: FROM psb_account_position_sets

635: l_tmp VARCHAR2(1);
636:
637: CURSOR c IS
638: SELECT '1'
639: FROM psb_account_position_sets
640: WHERE name = p_name
641: AND account_or_position_type = p_account_or_position_type
642: AND ( p_data_extract_id IS NULL
643: OR

Line 832: FROM psb_account_position_sets

828:
829: -- Retrive use_in_budget_group_flag to return additional information through
830: -- p_frozen_bg_reference parameter.
831: SELECT NVL(use_in_budget_group_flag, 'N') INTO l_use_in_budget_group_flag
832: FROM psb_account_position_sets
833: WHERE account_position_set_id = p_account_position_set_id;
834:
835: IF l_use_in_budget_group_flag = 'Y' THEN
836:

Line 962: psb_account_position_sets.account_position_set_id%TYPE ;

958: --
959: l_source_business_group_id psb_data_extracts.business_group_id%TYPE ;
960: l_target_business_group_id psb_data_extracts.business_group_id%TYPE ;
961: l_new_position_set_id
962: psb_account_position_sets.account_position_set_id%TYPE ;
963: --
964: CURSOR l_source_data_extract_csr IS
965: SELECT business_group_id
966: FROM psb_data_extracts

Line 1046: FROM psb_account_position_sets

1042: -- First copy all the global position sets.
1043: FOR l_global_sets_rec IN
1044: (
1045: SELECT *
1046: FROM psb_account_position_sets
1047: WHERE account_or_position_type = 'P'
1048: AND global_or_local_type = 'G'
1049: AND data_extract_id = p_source_data_extract_id
1050: )

Line 1093: psb_account_position_sets sets

1089: FOR l_local_sets_rec IN
1090: (
1091: SELECT sets.account_position_set_id
1092: FROM psb_set_relations rels ,
1093: psb_account_position_sets sets
1094: WHERE sets.account_position_set_id = rels.account_position_set_id
1095: AND sets.account_or_position_type = 'P'
1096: AND sets.global_or_local_type = 'L'
1097: AND sets.data_extract_id = p_source_data_extract_id

Line 1218: psb_account_position_sets.account_position_set_id%TYPE;

1214: --
1215: l_count NUMBER ;
1216: l_row_id VARCHAR2(50) ;
1217: l_account_position_set_id
1218: psb_account_position_sets.account_position_set_id%TYPE;
1219:
1220: l_line_sequence_id psb_account_position_set_lines.line_sequence_id%TYPE ;
1221: l_value_sequence_id psb_position_set_line_values.value_sequence_id%TYPE ;
1222: l_target_attribute_id psb_account_position_set_lines.attribute_id%TYPE ;

Line 1229: FROM psb_account_position_sets

1225: psb_position_set_line_values.attribute_value_id%TYPE ;
1226: --
1227: CURSOR l_sets_csr IS
1228: SELECT *
1229: FROM psb_account_position_sets
1230: WHERE account_position_set_id = p_source_position_set_id ;
1231: --
1232: CURSOR l_find_matching_attribute_csr
1233: (

Line 1290: FROM psb_account_position_sets

1286: -- Check whether the current position set already exists. If exists, then the
1287: -- set cannot be copied and a message is placed in the message stack.
1288: --
1289: SELECT count(*) INTO l_count
1290: FROM psb_account_position_sets
1291: WHERE account_position_set_id <> l_sets_rec.account_position_set_id
1292: AND name = l_sets_rec.name
1293: AND data_extract_id = p_target_data_extract_id ;
1294: